Skip to Content
0
Former Member
May 05, 2014 at 05:21 AM

Secondary index issue

71 Views

HI Experts

I am having certain doubts in Secondary index i,e..

for the table MSEG i created secondary index with LFBNR ,LFBJA, LFPOS fields ,Now in the select query if i used all these three fields in WHER condition then only the fetch will be fast ???

OR if i use any ONE of these three fields in WHERE condition then the fetch will be normal as non-key field fetch ??

PLease clarify me

Regards,

Lokesh Rangappa