Re: About an old hint question

If you have many of those, try setting _LIKE_WITH_BIND_AS_EQUALITY = TRUE (can be done with alter session) and potentially increase the selectivity of the column by reducing density by an order of magnitude or two.

At 04:11 PM 5/14/2003 -0800, you wrote:
>[...]

>The contention issue are the bind variables from PRO*C programs where
>things "LIKE :S" are usually resolved by using a full table scan,
>even if :S is of the form 'ABC%' in which case the query should, as
>we all know, use an index. The only solution that I have for the problem
>is to put a dreaded hint in the select.

[...]
Wolfgang Breitling
Centrex Consulting Corporation
http://www.centrexcc.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wolfgang Breitling
  INET: breitliw_at_centrexcc.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).