what is cluster and nin-cluster index?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is an inner join?

706


What is purpose of normalization?

700


What is an entity-relationship diagram (erd)?

803


In case you have filters in your report, when filters will be applied in cached report instance?

91


How to encrypt data between dialogs?

763






How to create prepared statements using odbc_prepare()?

776


Do you know what is fill factor and pad index?

745


You have a table ‘test’ which is a copy of northwind employee table you have written a trigger to update the field ‘hiredate’ with the current date

815


what kind of lan types do you know? : Sql server database administration

702


Define a cross join?

755


what changed between the previous version of sql server and the current version? : Sql server database administration

700


How to add a new column to an existing table with "alter table ... Add" in ms sql server?

755


Define union, union all, minus, intersect?

741


What is "scheduled jobs" or "scheduled tasks"?

724


You are designing a database for your human resources department in the employee table, there is a field for social security number, which cannot contain null values if no value is given, you want a value of unknown to be inserted in this field what is the best approach?

841