Can Somebody tell me the difference between Clustered & Non-
Clustered Index??
- 5 Answers
- 8131 Views
- Progressive, I also Faced
- E-Mail Answers
Answer Posted / vijaya
In Clustered Index, the data is physically sorted.
only one Clustered Index is created per table.
The data is stored in heap level of the B-tree.
In non-clustered Index, the physical order of the rows is
not same as the order of index.
there can be upto 249 non-clustered index per table.
the data is present in the random order but the logical
ordering is specified by the index.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How to get a list of columns using the "sys.columns" view in ms sql server?
What do you understand by a view? What does the with check option clause for a view do?
How do you trace the traffic hitting a sql server?
How to check status of stored procedure in sql server?
Why you need indexing? Where that is stored and what you mean by schema object? For what purpose we are using view?
What do you understand by the denormalisation?
Can you tell me some of the common replication dmv's and their use? : sql server replication
Explain indexed views and partitioned view with their syntax.
What is indexing in sql server with example?
List out a number of the wants to setup a SQL Server failover cluster?
What does select 1 mean?
What are the difference between “where” and “having” clause in sql server?
Tell me about pre-defined functions of sql?
What is ms sql server reporting services?
What is the data tier application?
