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.