From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Unlock the full course today

Join today to access over 24,800 courses taught by industry experts.

Views, object views, JSON views, and materialized views

Views, object views, JSON views, and materialized views - Oracle Database Tutorial

From the course: Complete Guide to Oracle Database 23ai: From Beginner to Advanced

Start my 1-month free trial Buy for my team

Views, object views, JSON views, and materialized views

“

- [Instructor] Let's jump into secondary database objects which provide enhanced performance and ease of management. The first topic we'll cover are views, which are essentially named queries that can simplify complex logic by presenting it as an object. Understanding how to use and interact with views is crucial for efficient database management. Views can provide users with an object name to replace complex SQL code, but it can also degrade performance if too complex of code is included. Always look at the cost of a step in an explained plan before deciding what should be included in where clauses when designing a view. Another common problem is views which join to other views, which is called nested views. The scenario can complicate the work for the Oracle optimizer when choosing the most optimal explain plan, especially when a secondary where clause is added to a simple select not realizing a more complex SQL statement is behind the view. As data grows and demands on how data is…

Contents