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 / alekhya

index is a database object used for increasing the
performance.

types of indexes:
1)simple index
2)composite index

Unique index
composite unique index
bitmap index
key compression index
function based index
cluster index
non-cluster index
Reverse key index

Is This Answer Correct ?    12 Yes 13 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is snowflake sql?

1068


differentiate between float and double. : Sql dba

1048


What are the three forms of normalization?

1040


How can one get sql*loader to commit only at the end of the load file? : aql loader

1053


what is msql? : Sql dba

984


What is the use of prepared statement?

1006


What is the difference between view and stored procedure?

959


Can a table contain multiple primary key’s?

1092


What is loop in pl sql?

1033


What is forward declaration in pl sql?

1071


What is union and union all keyword in sql and what are their differences?

1098


what tools available for managing mysql server? : Sql dba

1075


What are the syntax and use of the coalesce function?

1192


What is the difference between syntax error and runtime error?

1130


what is a constraint? : Sql dba

1144