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 |
How to insert multiple rows with a subquery?
What are the all different types of Joins in SQL Server 2000, Anybody can explain each join with definition..Thanks in advance....
9 Answers DELL, i Tech, Infosys, Siemens, TCS,
How to select some specific rows from a table in ms sql server?
How do SQL server 2000 and XML linked?
In which files does sql server actually store data?
what is the difference between sql query and google query?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What is the difference between indexing and hashing?
Can an automatic recovery be initiated by a user?
How does clustered and non clustered index work?
How to truncate the log in sql server 2012? : sql server database administration
How to add code to the existing article (using improve article)?
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)