O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required