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 using in sql?

1093


What is cross join example?

1007


What is a stored procedure in sql with example?

1131


What is the difference between left and left outer join?

944


What is meant by <> in sql?

978


What are different types of keys?

1106


How do I view tables in mysql?

986


What is Difference Between Unique and Primary Key Constraints?

1107


What are the different schemas objects that can be created using pl/sql?

1029


Which one is better sql or oracle?

969


what is recursive stored procedure? : Sql dba

986


Explain the the update statement in sql?

1038


what is blob? : Sql dba

1149


Can a table contain multiple foreign key’s?

997


Explain character-manipulation functions?

1133