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 / jay vardhan singh

Cluster is faster then non cluster index.We can use only
one cluster index on one table and we can use more then one
non cluster index on one table.

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define Wed Edition in SQL Azure?

100


What is the use of sign function?

1061


What is the need for indexing?

906


What are user defined functions in ms sql server?

942


How to update multiple rows with one update statement in ms sql server?

1161


Which tcp/ip port does sql server run on? How can it be changed?

991


What is sub query and its properties?

937


What are logical database components? : SQL Server Architecture

983


Explain what is lock escalation and what is its purpose?

897


How to make remote connection in database?

973


Can You Use Data Mining Models In Ssrs?

143


How do I trace a query in sql server?

916


What is 'write-ahead log' in sql server 2000 ?

1013


How to bind a view to the schema of the underlying tables?

960


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1959