1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

what is cluster and nin-cluster index?

Question Posted / guest

Answers were Sorted based on User's Feedback



what is cluster and nin-cluster index?..

Answer / vikram

Clustered index hold data at the leaf node.
non clustered hold data location (pointer) at the leaf node.
when we create primary key Clustered index automatically
created

Is This Answer Correct ?    9 Yes 0 No

what is cluster and nin-cluster index?..

Answer / 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

what is cluster and nin-cluster index?..

Answer / rajkumar

There can be only 1 Clustered index in a table

where as nonclustered index can be upto 249

Clustered is physical sorted index..

non clustered is logical stored index is faster than
clustered index

thats all i know

Is This Answer Correct ?    5 Yes 2 No

what is cluster and nin-cluster index?..

Answer / manisha

cluster index sorts the data ,so its affects the physical
arragement,while non clustered does not sorts the data.

a table can have max of 1 clustered index but can have upto
249 non clustered index.

Is This Answer Correct ?    3 Yes 0 No

Post New Answer

More SQL Server Interview Questions

Is there any difference between the primary key and unique key?

0 Answers  

Which system table contains information on constraints on all the tables created?

2 Answers  

What is an execution plan? When would you use it? How would you view the execution plan?

1 Answers  

Please explain that what are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture

0 Answers  

How to throw custom exception in Stored Procedure?

0 Answers   MCN Solutions,




What is it unwise to create wide clustered index keys?

0 Answers  

What are the types of resultset?

0 Answers  

can you any body tell me while running BCP Out in instance in sql server 2000 is getting error. Error = [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied.?

1 Answers  

how to write test cases for testing databases,especially for testing and writing test cases for stored procedures.any real time database testers.please answer me.

0 Answers  

How to insert stored procedure result into temporary table?

0 Answers  

How to insert a new row into a table with "insert into" statements in ms sql server?

0 Answers  

Explain alternate key, candidate key and composite key in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories