-
Book Overview & Buying
-
Table Of Contents
Microsoft SQL Server 2008 R2 Administration Cookbook
By :
Scalability and performance are the common buzzwords whenever we are dealing with large data sets, and to help further, indexes and statistics play an important role in query performance. A Database Administrator or Developer needs a good understanding of the indexing methods, which can result in efficient practices to return the required subset of data based upon the index key columns and their values.
Inside the database, the data is inserted, deleted, and updated frequently; to return subsequent results efficiently, indexes are helpful. However, NULL values are present in the data, and if it is likely that null values are stored in the data on a larger scale, the indexes will need efficient design for better performance.
In addition to the disk space required for Index DDL operations, temporary disk space is required for sorting (one new index at a time), unless the query optimizer finds the relevant execution plan that does not require...
Change the font size
Change margin width
Change background colour