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

Initially question was asked to mention the types of indexes.
Then asked about BITMAP INDEX and B-Tree Index

Answer Posted / slokh

Bitmap index is a type of index created on the basis of the
column having low cardinality like. index created on the
column like 'gender' etc.


B-tree or binary index is created on the column contains
wide range of values like 'name' column.

note:- more than one index is created on the table.

Is This Answer Correct ?    9 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of sql commands?

1117


what is auto increment? : Sql dba

1000


How do I sort a table in sql?

1025


Whis is not false in primary key?

1449


What are the types of triggers in sql?

1081


Which join condition can be specified using on clause?

943


Can delete statement be rollbacked?

980


What are the triggers associated with image items?

1034


How many row comparison operators are used while working with a subquery?

1027


Explain two easy sql optimizations.

1004


Can we perform dml in function?

1060


Is and as keyword in pl sql?

952


How do I run pl sql in sql developer?

1107


What are sql triggers used for?

987


How many triggers can be applied on a table?

928