Difference between Cluster and Non-cluster index?
Answer Posted / naren
clustered index is created on actual data.
Non clustered index ix created on pointer of data.
If there is primary key by default clustered index is
created.
else non clustered index created.
only one clustered index is possible to create.
249 non clustered indexex can be created.
Is This Answer Correct ? | 59 Yes | 15 No |
Post New Answer View All Answers
What is apply operator in sql?
What is the meaning of sql server?
How do I partition a table in sql server?
Explain the use of containers in ssis?
On a windows server 2003 active – passive failover cluster, how do you find the node which is active?
how do you determine the Load performance of any query in sql server {example how do u determine performance of a select stmnt which returns Dynamically many no of records ... some times 100,1000,10000 etc., }
What is co-related sub query?
what's the difference between a primary key and a unique key? : Sql server database administration
Explain where clause?
What is report subscription?
How to generate create function script on an existing function?
How do I setup a sql server database?
What are views in ms sql server?
what are defaults? : Sql server database administration
What is the impact on other user sessions when creating indexes?