SELECT statement with 'IN'

[Former Member]

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

[Former Member]

Moderator message - Please search before asking - post locked Rob