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 |
What is the simplest way to create a new database in ms sql server?
What are the basic functions for master, msdb, model, tempdb databases?
What is self contained scalar sub query?
What is hierarchy, what are its types and difference between them? : sql server analysis services, ssas
Explain about SQL server 2005?
How make remote connection in database?
How to Insert multiple rows with a single insert statement?
What are the advantages of paper records?
What is create command?
Explain what are the restrictions while creating batches in sql server?
How to give a user the option of importing Excel and a delimited text file into a SQL Server Database without manually using SQL DTS?
What does the on update no action do?
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)