Interested to Buy Any Domain ? << Click Here >> for more details...
What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 8002 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
Which is the latest version of sql server and when it is released?
How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?
What is row_number function?
Why is the need for data conversion transformations?
How to deploy the Report?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to add the custom code in Report?
What is raid and what are different types of raid levels?
Do you know what is blocking?
When I delete any data from a table, does the sql server reduce the size of that table?
How do I start sql server 2017?
List out the differences between the clustered index and non-clustered index in sql server?
How to defragment indexes with alter index ... Reorganize?
Can anyone tell that the extra features are there in SQL SERVER 2008 that are not available in previous versions .
you accidentally delete the msdb database what effect does this have on your existing sql databases, and how do you recover? : Sql server administration
