SQL Tunning Issue

From: Roman Gelfand <rgelfand_at_masmid.com>
Date: Tue, 4 Aug 1998 22:24:26 -0400
Message-ID: <6q8fhs$3vt$1@news.monmouth.com>

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 Tue Aug 04 1998 - 21:24:26 CDT