Skip to Content
0
Former Member
Sep 09, 2010 at 04:24 PM

SELECT statement with 'IN'

16 Views

Hi,

If SELECT statement has IN in the where clause, does that use the index?

For example,

SELECT t1 f2 f4 from ztest

WHERE

fid IN s_id AND

doctype IN s_doctype AND

year IN s_year .

What is the other option to optimize the SELECT with IN?

Thanks & regards,

Yogita