RE : RE: Query takes ages in Oracle 10G
- From: Isabel Bedoya <isabel_bga@xxxxxxxx>
- To: kevinc@xxxxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
- Date: Thu, 21 Sep 2006 17:19:39 -0400 (EDT)
:)
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@xxxxxxxxxxxxx> 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
--
//www.freelists.org/webpage/oracle-l
---------------------------------
Lèche-vitrine ou lèche-écran ? Yahoo! Magasinage.
Other related posts:
