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 do I create a stored procedure in dbml?
What are the restrictions while creating batches in sql server?
What is a natural primary key?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
In which format does an image save in SQL Server database ?
Explain difference between control flow and data flow?
what is syntex second or third highest salary. thanks & Regards Dhirendra sinha
Can multiple columns be used in sql group by clause in ms sql server?
What Is The Difference Between Primary Key & Super Key
How to modify an existing user defined function?
Explain about Normalization?
What is the Difference Between Primary and Foreign Key?
0 Answers Accenture, Deloitte, JPMorgan Chase, Maveric,
Oracle (3253)
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)