What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 7226 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 |
What is not null constraint?
Is there any difference between primary key and unique with the not null condition?
What is the difference between locking and multi-versioning?
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
What is difference between materialized view and view?
What is the difference between cross join and Full outer join?
What is blocking in SQL Server? If this situation occurs how to troubleshoot this issue
Write a program to fetch first 10 records from a file?
What is difference between line feed ( ) and carriage return ( )?
What is an indice?
What are scalar functions?
How to list all user names in a database?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
