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
- 7876 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 |
Which are ddl commands?
Difference between report and query parameter.
you have couple of stored procedures that depend on a table you dropped the table and recreated it what do you have to do to reestablish those stored procedure dependencies?
What is sql server used for?
How to connect to a sql server using odbc_connect()?
When would you use the stored procedures or functions?
What is a file group?
When would you use a before or after trigger?
Can we perform backup restore operation on tempdb? : sql server database administration
What is sql server replication? : sql server replication
What is the disadvantages of index?
When a primary key constraint is included in a table, what other constraints does this imply?
-
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)
