By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,590 Members | 2,174 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,590 IT Pros & Developers. It's quick & easy.

Index - DB2 tables

P: 1

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 will be taken or not ?

Please reply me.
Sep 11 '07 #1
Share this Question
Share on Google+
1 Reply

P: 9
Yes. it is taken, cause the in the join clause you use the col1, col2.

Sep 19 '07 #2

Post your reply

Sign in to post your reply or Sign up for a free account.