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

Can you index views?

932

When cursors are useful?

1168

How dts is used to extract, transform and consolidate data?

1111

What are date and time data types in ms sql server?

1158

Is foreign key a primary key?

1174

How to locate and take substrings with charindex() and substring() functions?

1070

Explain about temporary stored procedure?

1092

What are indexes in sql?

1349

What are character string data types in ms sql server?

1346

How to disable a login name in ms sql server?

1173

What are parameterized reports?

204

What is key attribute?

979

How to create an identity column?

1301

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

998

What is the difference between truncate and delete commands?

1107