Interested to Buy Any Domain ? << Click Here >> for more details...
In clustered and non clustered indexes which one is faster
while executing a query ?
- 1 Answers
- 7884 Views
- I also Faced
- E-Mail Answers
Answer / arunyadav007
Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.
Thanks,
Arun
| Is This Answer Correct ? | 13 Yes | 3 No |
How to copy the tables, schema and views from one sql server to another?
What are null values in ms sql server?
What happens if we shrink log file in sql server?
Can you explain what are the restrictions applicable while creating views? : SQL Server Architecture
What are the types of dml?
What is the difference between osql and query analyzer?
What is ACID Property of Transaction?
do you know what is a deadlock and what is a live lock? How will you go about resolving deadlocks? : Sql server database administration
what is an extended stored procedure? : Sql server database administration
What you can do to delete a table without the delete trigger firing?
What are the differences between local and global temporary tables?
what information is maintained within the msdb database? : Sql server administration
-
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)
