Difference between Cluster and Non-cluster index?
Answer Posted / veerreddy
clustered index is that the order of data in table is always
equal or matches to order of data stored in index.there is
only one(1) clustered index for table.it is usually applied
on primary key column in table.
other hand the non-clustered index is that the order of data
in table is not equal or matches to order of data stored in
index.so they can be applied on non-primary key columns like
unique,foreign key etc.A table can have (249) non-clustered
indexes
Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
What are the restrictions applicable while creating views? : SQL Server Architecture
mention different types of relationships in the dbms?
Can primary key be null?
What are types of storage modes? : sql server analysis services, ssas
How to create “dependant” parameter “make, model, year”
What happens on checkpoint?
What are drilldown reports?
What is the contrast between sql and pl/sql?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
what are the important architecture components of SSRS?
What is stretch database in sql server?
What number aggregate functions are accessible there in sql?
Explain about SQL server 2005?
What is postgresql server?
You are creating an application where users are asked their gender in the gender combo box you have three options: ‘male’ , ‘female’ and ‘i choose not to disclose’ these options are stored in the table as 1, 0 or null which datatype should you use?