RE : RE: Query takes ages in Oracle 10G

From: Isabel Bedoya <isabel_bga_at_yahoo.ca>
Date: Thu, 21 Sep 2006 17:19:39 -0400 (EDT)
Message-ID: <20060921211939.70940.qmail@web37915.mail.mud.yahoo.com>

:)    

  Not at all, I asked myself the same when I got this code. The developer wrote it like that... not my fault!..---> :)

Kevin Closson <kevinc_at_polyserve.com> a écrit :   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

--

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

---

Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.

--

http://www.freelists.org/webpage/oracle-l Received on Thu Sep 21 2006 - 16:19:39 CDT