materialized views

Thumbnail image for What are CBO and RBO?

What are CBO and RBO?

Oracle’s inbuilt optimizers – CBO and RBO: how they work to improve query performance, and key differences between cost-based vs rule-based optimization.

Read the Full Article →
Thumbnail image for The Difference Between Views and Materialized Views

The Difference Between Views and Materialized Views

Key differences between views and materialized views in Oracle, with guidelines to help you decide if a specific scenario needs a view, a materialized view, or neither.

Read the Full Article →