Re: How to force use of index

In <37ud5t$eof_at_athos.cc.bellcore.com> mjk_at_spanky.cc.bellcore.com (25994-kelly) writes:

>
>Does anyone see why this doesn't work? I traced it and the statements
>still do a full tablescan ....
>select ticketnum from /*+INDEX CTRIEC*/
>open_trouble_info where
>((center_lit = 0) and (customer_iec_code in (0)));
>
>
>select ticketnum from /*+CTRIEC*/
>open_trouble_info where
>((center_lit = 0) and (customer_iec_code in (1,0)));
>
>The index is on center_lit+customer_iec_code.
>

I think that you must have to use the index enforcement by giving following command

select ticketnum from /*+INDEX (TROUBLE_INFO CTRIEC)*/ open_trouble_info where
((center_lit = 0) and (customer_iec_code in (0)));

Also make sure that you have done the analyze command on this table. Received on Mon Oct 17 1994 - 22:38:52 CET