How to force use of index
From: 25994-kelly <mjk_at_spanky.cc.bellcore.com>
Date: 17 Oct 1994 17:44:29 GMT
Message-ID: <37ud5t$eof_at_athos.cc.bellcore.com>
Date: 17 Oct 1994 17:44:29 GMT
Message-ID: <37ud5t$eof_at_athos.cc.bellcore.com>
Does anyone see why this doesn't work? I traced it and the statements
still do a full tablescan ....
select ticketnum from /*+CTRIEC*/
select ticketnum from /*+INDEX CTRIEC*/
open_trouble_info where
((center_lit = 0) and (customer_iec_code in (0)));
open_trouble_info where
((center_lit = 0) and (customer_iec_code in (1,0)));
The index is on center_lit+customer_iec_code. Received on Mon Oct 17 1994 - 18:44:29 CET