Chapter 6. Optimizing Access to Data: Indexes
Perhaps the main reason to install a database system is to be able to search efficiently for data. Commercial systems use vast amounts of data, and users have come to expect a reasonably short response time when searching for information irrespective of how the search is carried out or the criteria used in the search.
Many other programming books and technical papers have already covered searching and sorting algorithms, so it is not the purpose of this book to introduce any new theories on this subject.
To produce results in the quickest and most efficient way, SQL Server must have fast access to the data. It does this by allowing every operation to have optimized access to any resource that it might ...
Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
