MCQs>Database Management>Oracle 10g Database Administration>An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?
Oracle 10g Database Administration MCQs
An index on the PASSPORT_RECORDS table has to be created. It contains 10 million rows of data. The key columns have low cardinality. The queries generated against this table use a combination of multiple WHERE conditions involving the OR operator.Which of the following index will be used for this criteria?
Answer
Correct Answer: Bitmap
Explanation:
Note: This Question is unanswered, help us to find answer for this one