What is sorting and what is the difference between sorting
and clustered indexes?
Answer / 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 |
Accidentally i deleted my table. How can i get that table?
How to edit table in sql server 2017?
What is a Lock and let me know Different types of locks?
How do triggers work?
What are the OS services that the SQL Server installation adds?
What is the use of nvl work?
what purpose does the model database serve? : Sql server database administration
How to delete duplicate rows from table except one?
Write a sql query to get zero records from a table having n number of records?
What is a filestream?
Why I am getting this error when dropping a database in ms sql server?
What is a join in sql?
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)