Sunday, 24 November 2013

What is sorting and what is the difference between sorting & clustered indexes?




  1. The ORDER BY clause sorts query results by one or more columns up to 8,060 bytes. This will happen by the time when we retrieve data from database. Clustered indexes physically sorting data, while inserting/updating the table.

No comments:

Post a Comment

Popular Posts