When do we create bitmap indexes
Answers were Sorted based on User's Feedback
Answer / guest
A.OLTP
B.DSS
C.Where clause has functions
D.Tables that have only one record
Is This Answer Correct ? | 19 Yes | 2 No |
Answer / 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 |
What are the advantages of sql? Explain
How can I speed up sql query?
Explain the savepoint statement.
How will you select unique values from a list of records?
how to insert the data through views? The view is depending upon more than two tables? how to update materalized views?
How many rows will return from dual table?
When can we use the where clause and the having clause?
What is difference between sql function and stored procedure?
in materialized view the structure will create immediately or not?
what are the different tables present in mysql? : Sql dba
what is query cache in mysql? : Sql dba
I want to create synonym for table emp but in my pc it is giving insufficient previliges.I am using user scott.Please suggest me.