MVSFORUMS.com

mnandakumar · Beginner Joined: 09 May 2007 Posts: 22 Topics: 14

Hi,

Following is the index (col1,col2,col3) created on the table TABLE1.In the query col1 and col2 are used in joins and col3 is used in where clause. Whether the index scan takes place or table scan takes place ?

Is it possible to use the index columns in joins as well as where clause?
It would be great help if someone provides me some material on index.

Thanks in advance

kolusu · Posted: Tue Sep 11, 2007 8:12 am Post subject:

mnandakumar,

Check this link which explains FAQ For Evaluating SQL queries

http://www.mvsforums.com/helpboards/viewtopic.php?t=587&highlight=index+match

Once you are done with explain Check this link which will answer your queries

http://publibz.boulder.ibm.com/cgi-bin/bookmgr_OS390/BOOKS/DSNAPJ12/6.4.2?DT=20050328013405

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