What is the difference between clustered and a non-clustered index?
- 1 Answers
- 1106 Views
- NA, I also Faced
- E-Mail Answers
Answer Posted / Ravi Rao Gautam
A clustered index determines the physical ordering of data in a table, while a non-clustered index stores the indexed columns and a reference to the location of the corresponding row in the clustered index or table. Each table can only have one clustered index, but multiple non-clustered indexes.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
List the ways in which dynamic sql can be executed?
Why we use the openxml clause?
What is temporary table in sql server? Why we use temp table?
What is self contained sub query?
What are the different SQL Server Versions you have worked on?
How to convert character strings into numeric values?
What are wait types?
What is the primary use of the model database?
What is an indexed view?
How to provide default values to function parameters?
What is subquery? Explain the properties of a subquery?
What are the different subsets of sql?
How raid can influence database performance?
Explain system functions or built-in functions? What are different types of system functions?
Can you index views?
