Advanced SQL Developer — Hard
Key points
- The hint bypasses the need to expand the view, saving processing time
- It allows the query to benefit from the pre-aggregated data in the indexed view
- Using this hint can optimize query performance when working with indexed views
Ready to go further?
Related questions