What is difference between clustered index and non clustered index?
- 1 Answers
- 1165 Views
- I also Faced
- E-Mail Answers
Answer Posted / Anup Kumar Srivastav
[{"clustered index": "A type of index that organizes the actual data in a specific order based on the indexed column. Only one table can have a single clustered index."}, {"non clustered index": "A type of index that stores the data rows in their original location and only creates an index to speed up search operations. A table can have multiple non-clustered indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
When should you use an instead of trigger?
How to convert character strings into numeric values?
What are different types of constraints?
How raid can influence database performance?
what is spatial nonclustered index
What is clustered index
Is it possible to have clustered index on separate drive from original table location?
If any stored procedure is encrypted, then can we see its definition in activity monitor?
What is the primary use of the model database?
List the ways in which dynamic sql can be executed?
How to enter binary string literals in ms sql server?
Is there any performance difference between if exists (select null from table) and if exists (select 1 from table)?
What is sql server query analyzer?
Can you index views?
How do I start sql server 2017?
