Interested to Buy Any Domain ? << Click Here >> for more details...
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 are the non-standard sql commands supported by 'mysql'? : Sql dba
Why is stored procedure faster than query?
What is the requirement of self-join?
Can a foreign key be null?
What are crud methods?
What is the usage of the distinct keyword?
how can I make a script that can be bi-language (supports english, german)? : Sql dba
Why is a primary key important?
what is the difference between a web-garden and a web-farm? : Sql dba
What is the maximum number of columns in sql table?
What is scalar function?
Is postgresql a server?
What is record data type?
Can two tables have same primary key?
What is the difference between a primary key and a unique key?
