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
Is pl sql different from sql?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Can you load data into multiple tables at once? : aql loader
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
How do you create a db file?
What is the difference between sql and t sql?
how to add a new column to an existing table in mysql? : Sql dba
Why partition by is used in sql?
What are sql queries used for?
What are the subsets of sql?
Which are the different case manipulation functions in sql?
Can we use pl sql in sql server?
What is record in pl sql?
What are tables in sql?
What is mdf ldf and ndf?
