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 is view? : Sql dba
what is External tables? explain with examples
What is the use of pl/sql table?
Is postgresql a nosql database?
Explain the uses of a database trigger?
Table name: T1, it has only one column. col1 ------ c b a b b b b d s a a t s Requirement: I need the following output from the above base table by using SQL query. col1 Cnt ----- ------- a 3 b 5 Others 5 Please help. Thanks Guru v.gurus@in.com
Difference between inline query and stored procedure?
Can any one tell me how to increase the performance of a sql query ie what are the performance tips in creating or writing a sql query !!?
What is a .db file?
What is Histogram?
Does sqlite need a server?
What is indexing oracle sql?