RE: Query takes ages in Oracle 10G

  • From: "Kevin Closson" <kevinc@xxxxxxxxxxxxx>
  • To: <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 21 Sep 2006 14:16:57 -0700

        SELECT *
        FROM   TITULO
        WHERE  TITULO_ESCENA_CODIGO___ = 'REAL'  AND
               TITULO_PORTAF_CODIGO___ = 'OBL'  AND
               TITULO_TIPTIT_CODIGO___ = 'TES_TF'  AND
               (TITULO_INDTITGAR IS NULL OR TITULO_INDTITGAR = 4) AND
               TITULO_FUTURO___ IS NULL  AND
               TITULO_ESTADO___ = 2 AND 
               TITULO_CLASIFICA <> 3 AND 
               TITULO_NUMERO___ NOT IN (SELECT OPETIT_TITULO_NUMERO___
                                        FROM   OPETIT, OPERAC


...does your T key stick on your keyboard?  Sorry, I couldn't resist




--
//www.freelists.org/webpage/oracle-l


Other related posts: