MCQs>IT & Programming>Oracle 9i Administration>You need to create an index on the ITEM table, which is 10 GB in size. You want your index to be spread across many tablespaces, decrease contention for index lookup, and increase scalability and manageability. Which of the following types of indexes would be the best for this table?
Oracle 9i Administration MCQs
You need to create an index on the ITEM table, which is 10 GB in size. You want your index to be spread across many tablespaces, decrease contention for index lookup, and increase scalability and manageability. Which of the following types of indexes would be the best for this table?
Answer
Correct Answer: Partitioned
Explanation:
Note: This Question is unanswered, help us to find answer for this one