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

how many bits ip address consist of? : Sql server database administration

902


What is a natural primary key?

1052


What is dynamic cursor in SQL SERVER?

1084


What does truncate do?

943


What is the boxing and unboxing concept in .net?

919


Why use “in” clause in sql server?

1074


What is the difference between ROW_NUMBER and Ranking function in SQL SERVER?

1147


What is the difference between varchar and nvarchar datatypes?

1090


Explain the concept of recursive stored procedure.

965


how to create “alternate row colour”?

146


How to create hyperlink from returned sql query ?

1128


What functions can a view be used to performed?

1060


I have a table Events Events containing cardno,time,id,name--each id has a cardno my requirement is every day each employee swipe the card several times i want to calculate first and last time of each card the output should be name 1 2 6 7 in out in out holiday holiday xxx 09:30 06:30 09:40 06:45 where 1,2...... are dates for example january 1,2, etc. 6 and 7 are saturday and sunday how it is posssible

2241


How do I run a trace in sql server?

988


What is database mirroring?

1121