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
What is primary key sql?
What is the difference between count 1 and count (*) in a sql query?
How many commands are there in sql?
What is db journal file?
What is pl sql variable?
What is localdb mssqllocaldb?
Is left join same as join?
what is a join? : Sql dba
Mention what plvcmt and plvrb does in pl/sql?
What are its different types of dbms?
What is right join in sql?
What is null in pl/sql?
What are sql*plus environment variables?
what is the syntax for using sql_variant_property? : Transact sql
What are pl/sql packages?