What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 7524 Views
- I also Faced
- E-Mail Answers
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 are partitioned views?
How to get the definition of a stored procedure back?
how to take backup bcp out for a column in table in sql server?
How many tables can be joined in SQL Server?
What is autocommit mode in sql server?
Explain unique key in sql server?
what is the information that can be stored inside a bit column? : Sql server database administration
What is the use of attributehierarchyvisible ? : sql server analysis services, ssas
what type of index will get created after executing the above statement? : Sql server database administration
Which is the best place or learning center for MS SQL?????In Bangladesh?????
What are logical/boolean operations in ms sql server?
What is the recovery model? List the types of recovery model available in sql server?
What is the purpose of the master database?
Which tcp/ip port does the sql server run on? How can it be changed?
How would you use user_constraints table in DB?
