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...

  1. Categories >> Software >> Databases >> SQL PLSQL
  2. Suggest New Category

What is an index and types of indexes. How many number of
indexes can be used per table ?

Question Posted / sandip kumar chaturvedi

Answer Posted / sandip kumar chaturvedi

index is a data structure that improve the operation on
table.there are two types of index.
1) ordered index.
2) hashed index.
up to 249 clustered indexes per table.

Is This Answer Correct ?    20 Yes 33 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the string functions in sql?

977

How to fetch values from testtable1 that are not in testtable2 without using not keyword?

1224

How much does sqlite cost?

1041

what is a view? : Sql dba

1095

Why indexing is needed?

988

How do you update a sql procedure?

1030

What is normalization sql?

1061

How to install oracle sql developer?

1047

What is the difference between database trigger and stored procedure?

1075

Explain the uses of database trigger.

1116

Explain raise_application_error.

1099

What is scalar function?

1054

what is the difference between char_length and length? : Sql dba

1046

How does index help in query performance?

1029

What are views in sql?

990