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

How to configure odbc dsn with different port numbers?

0 Answers  

What's the purpose of Stored Procedure?

6 Answers   Wipro,

What is MSDE?

2 Answers  

what is web server?

3 Answers   Satyam,

What is a sub-query? When would you use one?

3 Answers  

What is database replication? What are the different types of replication you can set up in sql server?

0 Answers  

What are examples of triggers?

0 Answers  

What do you mean by tablesample?

0 Answers  

Explain system views?

0 Answers  

1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

0 Answers  

When we should use and scope of @@identity?

0 Answers  

How to rebuild indexes with alter index ... Rebuild?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories