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 |
Explain alternate key, candidate key and composite key in sql server?
What are the new security features added in sql server 2012? : sql server security
Define ACID properties in a Database?
What are character string data types in ms sql server?
Explain what is raid and what are different types of raid levels?
How do I connect to sql server database?
What is stored in the mssqlsystemresource database? : sql server database administration
Can we have more than one NULL in a column having unique constraint?
What is the function of inner join?
How will u test the stroded procedures and functions? difference between SP and Triggers
How do you persist objects, permissions in tempdb
How do you optimize Sql queries ?
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)