MVSFORUMS.com

Meena · Beginner Joined: 03 Aug 2004 Posts: 20 Topics: 15

The scenario is..
for TABLE1 , there are 2 indexes defined
1)I1 on columns,
A1,A2,A3 & A4
2) I2 on columns
A4,A1,A2 & A3

Explain shows the usage of I1 index, only for the queries which have A1,A2 and A3 in the where clause
If A4 field is included in the query along with A1,A2 and A3 , then Index I2 is used even though A4 is a part of I1 index.

I want to know why this is happening and also if i can drop any one index , as both the indexes have the same set of fields but in different order.
Help at the earliest will be appreciated.
Thanks

kolusu · Posted: Tue Aug 03, 2004 5:37 am Post subject:

Meena,

Check the link which explains in detail about questions about data access

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAGH10/5.10.2?DT=20010212102121

Hope this helps...

Cheers

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

Meena · Beginner Joined: 03 Aug 2004 Posts: 20 Topics: 15

thanks .. it really is helping me