Oracle Exadata Smart Scan is one of the most important performance features of the Exadata Database Machine. It pushes parts of SQL processing—mainly predicate filtering and column projection—down to the Exadata storage cells. Instead of sending every block from storage to the database tier, the storage cells scan the data, apply eligible WHERE conditions, return … Continue reading Exadata Smart Scan Preventors