Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
Log in  ::  Register  ::  Not logged in

Content with tags Indexing, Execution Plans Rss

   Items 1 to 3 of 3   

How efficient is your covered index?

Observing an index seek utilizing a composite index within SQL execution plan might be more than meets the eye – you should look again.  Read more...
By Simon Liew 2013/08/12 | Source: | Category: covering index
Rating: |  Discuss |   Briefcase | 8,365 reads

Partitioned Tables, Indexes and Execution Plans: a Cautionary Tale

Table partitioning is a blessing in that it makes large tables that have varying access patterns more scalable and manageable, but it is a mixed blessing. It is important to understand the down-side before using table partitioning.  Read more...
By Additional Articles 2012/11/08 | Source: SimpleTalk | Category: partition table
Rating: (not yet rated)  Rate this |   Briefcase | 3,990 reads

SQL Server Index Statistics

Are your index statistics up to date? The SQL Server database engine uses statistics to determine which execution plan to use when a query is compiled. Index statistics are used to help the SQL Server engine determine the cardinality of different column values in a SQL Server table. If you want to give SQL Server a fighting chance at picking an optimal execution plan then you need to make sure you maintain your index statistics.  Read more...
By Additional Articles 2011/09/14 | Source: Database Journal | Category: indexing
Rating: (not yet rated)  Rate this |   Briefcase | 3,399 reads
   Items 1 to 3 of 3   
covering index (1)    
index seek (1)    
partition table (1)