Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

What are sparse columns?

0 Answers  

What is meant by Active-Passive and Active-Active clustering setup?

0 Answers  

What does dml stand for?

0 Answers  

What are acid properties of transaction?

0 Answers  

How to store and query spatial data?

0 Answers  

What would be the Expected Salary For SQL Server Developer for 3 years exp. as per indian market?

7 Answers  

If suppose in a table ship(name,year),find ship name having first and last name(i.e having space in between) ex: SAINT LOUIS,JET LAKE.

4 Answers  

what is Constraint? How many types of constraints in SQL ?

38 Answers   HCL, IBM, NIIT, Wipro,

Why do we use sql limitations? Which constraints can we use while making a database in sql?

0 Answers  

What are user defined functions in ms sql server?

0 Answers  

What is the default value of CHAR type?

10 Answers   Bosch,

Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,

For more SQL Server Interview Questions Click Here
Categories