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

When do we create bitmap indexes

Answer Posted / hitendra yadav

If there is very less cardinality (i.e. 1% of total column
values) or distinct values in column then we have to create
BITMAP index for that column like GENDER column will always
have 2 values MALE or FEMALE.

Syntex:-

Create bitmap index index_name on table_name(column_name);

Is This Answer Correct ?    17 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is primary key sql?

947


What is the difference between count 1 and count (*) in a sql query?

902


How many commands are there in sql?

970


What is db journal file?

952


What is pl sql variable?

931


What is localdb mssqllocaldb?

1014


Is left join same as join?

936


what is a join? : Sql dba

960


Mention what plvcmt and plvrb does in pl/sql?

1061


What are its different types of dbms?

955


What is right join in sql?

1018


What is null in pl/sql?

1018


What are sql*plus environment variables?

1029


what is the syntax for using sql_variant_property? : Transact sql

984


What are pl/sql packages?

1035