AI give me Execution Order follow this example
PARTITION RANGE ITERATOR
TABLE ACCESS BY LOCAL INDEX ROWID BATCHED
INDEX RANGE SCAN
Actual Execution Order :
Partition Pruning: PARTITION RANGE ITERATOR evaluates predicates (e.g., ORDER_DATE = '2023-01-01') to select partitions (e.g., Pstart=5, Pstop=5).
For Each Pruned Partition:
INDEX RANGE SCAN: Scans the local index (e.g., CUSTOMER_ID = 123).
TABLE ACCESS BY LOCAL INDEX ROWID BATCHED: Fetches table rows.
AI Explanation: Partition pruning is an exception.
It prioritizes the indented part. In fact,
I want to know whether partition pruning and local index can work together,
that is, partition pruning locates the partition that meets the conditions,
and then locates the record through the local index. But this order is very important.
Is AI right? I have always been confused by the indentation in the plan