Database »

The index-only scan belongs to the most powerful tuning methods at all. It utilizes not only the clustering of rows with similar values, but also exploits the fact that the index has a copy of the indexed data.
Posted by girish.r 590 days ago (http://use-the-index-luke.com)
Discuss  | Bury | Tweet This | Tagged: sql optimization index only tips tricks developers
Add To 

Who Voted for this Story

Comments

No one has commented on this article yet.

Log in to comment or register here.