Re: Help - PL/SQL and the LIKE clause

Try to use OPTIMIZER_MODE = RULE in initORCL.ora

Gocha

ronb8168_at_my-dejanews.com wrote in message <731ui4$v3r$1_at_nnrp1.dejanews.com>...
>Hi,
>
>If you code a select statement in PL/SQL where the LIKE clause uses a
>variable instead of a literal (example WHERE COL1 LIKE VAR_NAME vs. WHERE
>COL1 LIKE 'VALUE%'), even though the value in the variable does not have a
%
>in the front of the value, the optimizer does a full table scan instead of
an
>index scan.
>
>
>Does anyone know a trick to tell the optimized to do an index scan short of
>using an INDEX hint?
>
>Thanks
>
>Ron B
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Fri Nov 20 1998 - 06:18:02 CST