Db2 Index in table search

Keanehelp · New User Joined: 27 May 2008 Posts: 71 Location: USA, CA.

Hi,

I have doubt regarding DB2 indexes. In a where clause if we are using indexed column and we are also using a non indexed column then how DB2 will search the table? Is it like

First sort on indexed column and within those indexed column search and match rest of the conditions in where clause?

Any help is much appreciated.

thanks

Nitin.

dick scherrer · Posted: Mon Jan 19, 2009 7:11 am

Hello,

Believing you were asking a strictly db2 question, i moved your topic to the db2 part of the forum

DB2 will evaluate the query and attempt to determine the optimal way to access the data. If there are 2 columns named in where, the access is usually "driven" as you suggest - by the column with the index and then the other column.