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 is an index and types of indexes. How many number of
indexes can be used per table ?

Answer Posted / rm thirunavukkarasu

Index is used to Retrive the Information in efficient
manner. And query processor perform reliably.

There are 3 types of Index namely
*Cluster based Index
*Non Cluster based Index
*Noncomposite Index
*Compositive Index
*Unique Index

For more info adt sql plz visit www.thiruna.blog.com

Is This Answer Correct ?    8 Yes 16 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is write ahead logging in sql server?

1101


Does sql support programming?

1118


What is the largest value that can be stored in a byte data field?

1060


How can we optimize a sql query?

1114


Is subquery faster than join?

1064


List the various privileges that a user can grant to another user?

1098


How many sql are there?

1053


Can you join a table to itself?

1227


Is left join inner or outer?

1060


How do sql triggers work?

1096


What are inner and outer joins examples of both?

1013


Can we use two order by clause in query?

1020


What are the subsets of sql?

1200


How much does sqlite cost?

1094


describe transaction-safe table types in mysql : sql dba

1065