THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » nonclustered in... » index hints   (RSS)
  • Geek City: Using a Nonclustered Index to Avoid a Sort

    Most of you are probably aware that having a clustered index on the column(s) in an ORDER BY clause means that SQL Server can avoid having to sort your data, because it is already logically stored in order of the clustered index, and SQL Server can just access the data in order to get the sorted data . For example, consider the SalesOrderHeader ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on December 2, 2008
  • Did You Know? Forcing a nonclustered index scan to avoid sorting

      Hopefully, if you know enough about SQL Server to understand most of my posts here, you're aware of the fact that using a nonclustered index is not always an optimal choice for accessing data, particularly if there are thousands (or more) rows of data you need to retrieve.  However, we should never say 'never'. ...
    Posted to Kalen Delaney (Weblog) by Kalen Delaney on July 22, 2007
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement