Home
Up
About
Certifications
SVEK News Page
tips and tricks
Tip of the day
Summary of Skills
SQL Server Tips
Some interesting sites
Interesting sites
Guest Book
Contact Information
Software Development
Services
CompanyHistory

Covering Indexes

Define a normal index which includes all the data for the query. This index can then be used to extract all the data without ever hitting the main data pages.

This gives a good performance and is not too expensive in terms of storage.

Use performance analyser to indicate the indexes being covered.

Home ] Up ]

Send mail to Webmaster with questions or comments about this web site.
Copyright©1999 SVEK Computing Ltd
Last modified: January 27, 2003