View previous topic :: View next topic
|
Author |
Message |
mailsaurabh.tripathi
New User
Joined: 22 May 2008 Posts: 56 Location: hyderabad
|
|
|
|
Can someone provide me info on how does DB2 perform index only access? |
|
Back to top |
|
|
dick scherrer
Moderator Emeritus
Joined: 23 Nov 2006 Posts: 19244 Location: Inside the Matrix
|
|
|
|
Hello,
By only accessing the index?
Your question is not clear. . .
What are trying to learn? |
|
Back to top |
|
|
Steve Davies
New User
Joined: 15 Oct 2009 Posts: 32 Location: UK
|
|
|
|
If all the columns you want to retrieve are in the index, then it can meet your select statement criteia by only going to the index, therefore it does not need to go to the tablespace to get any extra columns. This is an index only access. It is more efficient for obvious reasons. |
|
Back to top |
|
|
|