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

what is the information that can be stored inside a bit column? : Sql server database administration

1010


code to create procedure for taking databse backup in sql server or i have the query for it but what it's query returns means i want to show on my jsp that the databse backup has been taken on the basis of that return value.does it returns 0 or 1.wat is the code for that

2256


Your table has a large character field there are queries that use this field in their search clause what should you do?

926


What are the difference between data mart and data warehouse? : sql server analysis services, ssas

1012


What is replication and database mirroring?

1091


Write a sql query to sort on different column name according to the parameters passed in the function?

964


What is the minimum and maximum number of partitions required for a measure group? : sql server analysis services, ssas

1104


What is the simplest way to create a new database in ms sql server?

1052


How connect excel to sql server?

1054


What happens if we shrink log file in sql server?

1033


Can we use having clause without group by?

1032


What are policy management terms?

1041


What is the difference between row_number and dense_rank?

936


How to receive output values from stored procedures?

1236


How to convert binary strings into integers in ms sql server?

1082