What is the basic difference between clustered and a
non-clustered index?
Answer Posted / santosh kumar
Index is Used for fast access the data.
Cluster Index is Unique in a table.One Table Contains Only
one Cluster Index but 249 Non Cluster Index is
Possible.Cluster Index is a Physical Storage and Non cluster
Index is a logical storage of the data.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
Can you edit the .rdl code associated with a linked report?
Explain different types of collation sensitivity?
Does view occupy space?
What is wide table?
what is nonclustered index
Explain what is the function of sql server agent windows service?
How to get a list of columns in a view using "sys.columns" in ms sql server?
What is not null constraint?
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How will you know when statistics on a table are obsolete?
How to get a list all databases on the sql server?
What is read committed?
What are the steps you should follow to start sql server in single-user mode?
What are different backups available in sql server?
What is the use of =,==,=== operators?