Skip to Content
0
Former Member
May 30, 2008 at 06:37 AM

Use of index

17 Views

Hi gurus,

Let's say I have a (primary) index on a table

F1 F2 F3 F4 F5 F6

Then in my select statement on this table, I use

where F3 = SOMEVALUE and F4 = SOMEVALUE

Will this index be used? and why?

Thanks a lot!

/BR

Ben