fields for index ? - a basic Qs.

select * from table
where field1 is null AND ( field2 = 'X' OR field3 = 'Y');

What , how many indexes to be created for this Query to run on an index scan ? Received on Wed Oct 04 2000 - 01:28:58 CDT