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

In clustered and non clustered indexes which one is faster
while executing a query ?

Question Posted / venkat


In clustered and non clustered indexes which one is faster while executing a query ?..

Answer / arunyadav007

Clustered Index.
Because the leaf level of a clustered index is the actual
data and the data is resorted in case of clustered index.
In case of non-clustered index the leaf level is actually a
pointer to the data in rows. The data is stored in one
place, the index in another, with pointers to the storage
location of the data. The items in the index are stored in
the order of the index key values, but the information in
the table is stored in a different order.

Thanks,

Arun

Is This Answer Correct ?    13 Yes 3 No

Post New Answer

More SQL Server Interview Questions

Explain the storage models of OLAP?

1 Answers  

Write a SQL command to insert and update only a particular field?

0 Answers   ADITI,

what are three different authentications to connect linked servers?

1 Answers   CitiGroup,

What is DCL?

0 Answers  

There is table like Events...in that name ,startdate ,enddate,location are the column names write a stored Procedure for this table to get events by Months "GetEventsByMonths"

2 Answers  




What is a deadlock and what is a live lock? How will you go about resolving deadlocks?

7 Answers   Microsoft,

What is sql injection? How to protect against sql injection attack?

0 Answers  

What is the difference between varchar and varchar(max) datatypes?

0 Answers  

What is named query? : sql server analysis services, ssas

0 Answers  

What is difference between views and stored procedures?

0 Answers  

What is the difference between UNIQUE and DISTINCT keywords in DBMS?

1 Answers   Genpact,

What are the differences between having and where clause.

0 Answers  

For more SQL Server Interview Questions Click Here
Categories