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
Explain the structure of pl/sql in brief.
I need a function for a train ticket reservation please answer it thanks in advance
What is foreign key and example?
What is difference between mysql and postgresql?
What is sqlservr exe?
- Types of triggers - View - Dcl - Procedures, packages, functions - Metasolve - Can use Dcl in triggers - package case study - Cursor and its types - triggers schedule - Wrap - Why we are using fetch and for in cursor. difference?
How does postgresql compare to "nosql"?
what are the 'mysql' command line options? : Sql dba
What is a dirty read sql?
What does subquery mean in sql?
Is join and inner join the same?
what happens if null values are involved in expressions? : Sql dba
What is an example of translating a date into julian format?
How can a function retun more than one value in oracle with proper example?
how to return query output in html format? : Sql dba