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
- 7967 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 |
What is abstracting periodical?
How to find the source of a table in sql server?
How do I start sql server 2016?
What is a database table?
Write an sql query to find first weekday of the month?
What is role playing dimension with two examples? : sql server analysis services, ssas
How to get number of days in a given year?
How to fetch the next row from a cursor with a "fetch" statement?
Can a database be shrunk with users active?
What the different types of Replication and why are they used?
What is RMS migrations?
What is microsoft sql server?
-
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)
