Skip to Content
0
Former Member
Feb 28, 2010 at 10:28 AM

Index on tables

16 Views

I will be requesting indexes on a table but not sure whether I need to request two seperate or just one index. My WHERE clause has an OR clause for example:

WHERE field1 in ...

OR field2 in ....

Do I need to create one index field1, field2 or do I need two indexes field1 and field2

Thanks