Re: SQL Tunning Issue

when objid is not a number filed , use the qoutes ('12445','12446') because Oracle will translate this.

On Tue, 4 Aug 1998 22:24:26 -0400, "Roman Gelfand" <rgelfand_at_masmid.com> wrote:

>It appears that when multiple values are used in the IN clause, Oracle gets
>very confused.
>
>In the following example
>
>select type from sec_view where objid in (12445, 12446);
>
>When using the tkprof to explain this statement, it tells me that a full
>table scan is done on this table eventhough the objid is indexed uniquely.
>Also, this table has been analyzed and it's size is 300,000 rows.
>
>Since I can not change this query nor the view, can anyone suggest how I
>could force Oracle to use indexes in this situation (since I can not change
>the query or the view, the hint can not be used).
>
>Thanks
>
>
>
Received on Thu Aug 06 1998 - 06:50:41 CDT