Index on tables

[Former Member]

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

[former_member194669]

I think if you have 2 indexes, one on FIELD1, and the other on FIELD2. then the system will be try to match index access on either index.

If you have only 1 index on FIELD1+FIELD2 then it is not possible that one index can satisfy both predicates in the WHERE clause.

a®

[former_member192616]

Hi,

> I think if you have 2 indexes, one on FIELD1, and the other on FIELD2.  then the system will be try to match index access on either index.
> 
>  If you have only 1 index on FIELD1+FIELD2 then it is not possible that one index can satisfy both predicates in the WHERE clause. 
> 
>  a®s

would you explain what you mean with an example please? It sounds a little bit strange...

Kind regards,

Hermann