Why Oracle Exadata Smart Scan Sometimes Does NOT Trigger?
In Exadata environments, Smart Scan normally activates automatically when Oracle performs a full table scan with direct path reads.However, in several real-world scenarios, the database optimizer cannot offload the work to storage servers, so Smart Scan does not occur. Below are the most common technical reasons. 1. Query Uses Index Access Instead of Full Table […]