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
How do you go back in sql?
What is difference between joins and union?
Why truncate is faster than delete?
Can a commit statement be executed as part of a trigger?
What is user defined functions?
how to calculate expressions with sql statements? : Sql dba
Is sql port 1433 encrypted?
what does the t-sql command ident_current does? : Transact sql
What has stored procedures in sql and how we can use it?
What are pl sql procedures?
how to get a list of all tables in a database? : Sql dba
How do I sort a table in sql?
What is the difference between partitioning and sharding?
1. is it possible to use the cursor atttibutes (%found ,% rowcount , %isopen , %notfound ) to our user defined cursor names ....... cursor cursor_name is select * from scott.emp if you use... cursor_name%found , %rowcount ,%isopen,%notfound...will it work... -------------------------- 2.what is the difference between the varray and index by table .. -------- 3. type type_name is table of number(8,3) index by binary_integer; identifier_name type_name; first , last , prior , next ,trim are the methods we can use it for the above type...simillary is there any way to apply for cursors... with thanks and regards..sarao...
how many triggers are allowed in mysql table? : Sql dba