Interested to Buy Any Domain ? << Click Here >> for more details...
What is sorting and what is the difference between sorting
and clustered indexes?
- 1 Answers
- 7953 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 |
How can a database be repaired?
Explain use of expression builder.
What is the maximum row of a size?
How does using a separate hard drive for several database objects improves performance right away?
What is storeprocedure?Tell me synatx for how to write stored procedure.
Can a cursor be updated? If yes, how you can protect which columns are updated?
Let us say the SQL Server crashed and you are rebuilding the databases including the master database what procedure to you follow?
What is difference between foreign key and unique key?
What is sql server query analyzer?
What is a data source or ds? : sql server analysis services, ssas
How can I check that whether automatic statistic update is enabled or not?
What are the 7 disadvantages to a manual system?
-
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)
