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
what is a check constraint?
Explain “row_number()” in sql server with an example?
What are trace flags and mention a few common trace flags used with sql server?
You have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation?
What causes index fragmentation?
What objects does the fn_my_permissions function reports on? : sql server security
What is index in an assignment?
Why we need to use secondry database file? though, we can do same work using primary database file also.
What is sql collation?
What is bit data type?
How to change the name of a database user?
What is the tcp/ip port on which sql server runs?
What are the transaction properties?
Where is my database stored on the hard disk in ms sql server?
What are the types of table?