Oracle
1Z0-536 · Question #37
Which two features provide performance benefits in a similar way?
The correct answer is A. Partitioning and Storage Indexes. The storage index can be used as an additional partitioning strategy if the data to be loaded is sorted on the additional partitioning column.
Smart Scan Technology
Question
Which two features provide performance benefits in a similar way?
Options
- APartitioning and Storage Indexes
- BStorage Indexes and Parallelism
- CPartitioning and parallelism
- DModel scoring and Partitioning
How the community answered
(63 responses)- A71% (45)
- B8% (5)
- C5% (3)
- D16% (10)
Explanation
The storage index can be used as an additional partitioning strategy if the data to be loaded is sorted on the additional partitioning column.
Topics
#storage indexes#partitioning#data pruning#performance
Community Discussion
No community discussion yet for this question.