Interested to Buy Any Domain ? << Click Here >> for more details...
When do we create bitmap indexes
- 2 Answers
- 10064 Views
- CTS, I also Faced
- E-Mail Answers
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 types of keys?
what tools available for managing mysql server? : Sql dba
Which query operators in sql is used for pattern matching?
What are primary key and foreign key and how they work?
What is clustered index sql?
What are secondary keys?
What is referential integrity ?
counting the no.of characters occurs in a string by using pl/sql function
What are the different set operators available in sql?
What is query syntax?
What does select top 1 do in sql?
how to present a past time in hours, minutes and seconds? : Sql dba
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
