|
View previous topic :: View next topic
|
| Author |
Message |
mosinjamadar
New User
Joined: 26 Sep 2007
Posts: 42
Location: pune
|
|
|
|
Hi
If I have defined INDEX on COLUMN1 COLUMN2 COLUMN3 and in SELECT
query in WHERE clause i will specify only COLUMN1 COLUMN2 still DB2 does INDEX scan or it will be sequential scan |
|
| Back to top |
|
 |
acevedo
Active User
Joined: 11 May 2005
Posts: 344
Location: Spain
|
|
|
|
| maybe column1 and column2 are not good candidates for index or try runstats. |
|
| Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006
Posts: 6966
Location: porcelain throne
|
|
|
|
do you mean table scan? |
|
| Back to top |
|
|
acevedo
Active User
Joined: 11 May 2005
Posts: 344
Location: Spain
|
|
|
|
now that I've read again the post:
DB2 should choose Index Access with Matchcols=2. |
|
| Back to top |
|
|
|
|
