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...

What are the type of Indexes? which one is best, why?

Answer Posted / arun pandey

Hi

1)Clustered Index
2)NON-Clustered INdex

But Clustered index is better than non-clusted
becoz the searching in clusterd is faster than non-clustered

Arun Pandey
A1Technology

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is index in an assignment?

912


What triggers long term care?

1003


Explain for xml explicit mode?

930


Explain what are the basic functions for master, msdb, model, tempdb databases?

931


Is the order of columns in the set clause important in ms sql server?

939


What do you understand by sql server agent?

929


What is the preferred way to create a clustered and non-clustered index? Which index should you create first the clustered or non-clustered?

873


What is an entity-relationship diagram (erd)?

1145


What are the triggers in sql?

1045


whats the maximum size of view state??

2157


Do you think BCNF is better than 2NF & 3NF? Why?

1239


how to determine the service pack currently installed on sql server? : Sql server database administration

932


How does the report manager work in SSRS?

146


Does partitioning help performance?

900


What program is used to store the data source file?

925