cluster Index create leaf level of (actul data) data. Non-cluster Index c

what is cluster and nin-cluster index?

Question Posted / hari

Answer Posted / hari

cluster Index create leaf level of (actul data) data.
Non-cluster Index create pointer level of data.

Is This Answer Correct ?

4 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is meant by indexing files?

1025

Is it possible to run multiple publications and different type of publications from the same distribution database? : sql server replication

971

What is linked report?

129

How to list all user names in a database?

1038

List the different index configurations possible for a table?

923

How many instances per computer are there in sql server 2000?

1045

What is the function of sql server agent windows service?

1068

What are the Advantages of using CTE in sql server?

1095

Write the queries for commands like Create Table, Delete table, Drop Table etc.

1073

What is the difference between truncate and delete commands?

1047

What is the openxml statement in sql server?

1052

What are synonyms?

952

How you can find out if an index is useful to the optimizer?

921

What are acid properties of transaction?

935

How can you insert values in multiple rows using one Insert statement?

1078