How to get query to use an index

From: Josh Collier <collier_jw_at_comcast.net>
Date: Tue, 11 Apr 2006 13:13:16 -0700
Message-Id: <20060411201327.35FEC2E4331@turing.freelists.org>

Query is currently using a full tablescan

There are two indexes.

One on cus01wrph
One on cushoph

If I just put in one or the other (either cusoph or cus01wrph) then the index is used.

SELECT cus.cusky, cus.cliky, cus.cus01frnm, cus.cus01lanm, cus.cusblad01,
       cus.cusblad02, cus.cusblcity, cus.cusblstate, cus.cusblzip,
       cus.cusblcntry, cus.cusad01, cus.cusad02, cus.cuscy, cus.cusst,
       cus.cuszp, cus.cuscountry, cus.cus01email, cus.cushoph, cus.cus01wrph,
       cus.wpa_change

  FROM cus_current_row cus
 WHERE ( cushoph LIKE SYS_CONTEXT ('MY_CTX_wpaods', 'phone')

        OR cus01wrph LIKE SYS_CONTEXT ('MY_CTX_wpaods', 'phone')
       )

Thanks for your help,

Josh C.

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

Received on Tue Apr 11 2006 - 15:13:16 CDT