What is sorting and what is the difference between sorting
and clustered indexes?
Answer Posted / saravakumar
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.
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
Can you explain various data region available in ssrs with their use?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What are the security related catalog views? : sql server security
What is indexing in sql server with example?
What are three ways you can use an identity value inside a trigger? Why would you prefer one way over another?
What is a file group?
What is the benefit of normalization?
How to concatenate two character strings together?
How to find the list of fixed hard drive and free space on server?
What is stored in the mssqlsystemresource database? : sql server database administration
What is surrogate key? : sql server analysis services, ssas
How to insert and update data into a table with "insert" and "update" statements?
How to select some specific columns from a table in a query in ms sql server?
Describe and explain about SQL native client?
What are the different types of replication are there in sql server 2000?