Skip to Content
0
Former Member
Dec 15, 2008 at 03:40 PM

Secondary Index Usage

29 Views

Hi,

Can I use extra field with Index in where clause. e.g. for selecting from MSEG table there is one index available MSEG-M which has 5 fields, but i need one more field which is not in index. So now in my where clause there will be 6 fields, 5 from index and 1 field i added. In this case whether the Index will work OR not?

Any response will be highly appreciated.

Cheers,

Lokesh.