What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 8117 Views
- I also Faced
- E-Mail Answers
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 |
Distinguish between nested subquery and correlated subquery?
what is mean by constraints in sql?
What is the security principal at the database level that represents your session?
can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?
What is database replicaion? What are the different types of replication you can set up in SQL Server?
What is the full form of dql?
What do you mean by table and field in sql?
What is resource governor?
How to end a stored procedure properly in ms sql server?
What does it mean to have quoted_identifier on? What are the implications of having it off?
Define views.
What is a sql join?
-
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)
