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

Explain how to send email from sql database?

1057


how many layers of tcp/ip protocol combined of? : Sql server database administration

1007


What is the difference between Normalization and De-normalization?

1101


What are the types of indexing?

1085


What are the steps to process a single select statement?

951


Why normalization is used?

1019


What is data block and how to define data block size?

1037


Why variables called the most powerful component of ssis?

1087


Can we call stored procedure in trigger?

955


Is sql server a database?

1006


What type of Index will get created after executing the above statement?

1107


What is acid properties?

1110


What is the difference between cube operator and rollup operator? : SQL Server Architecture

1131


can a database be shrunk to 0 bytes, if not, why? : Sql server administration

1221


What does ss stand for sexually?

1095