Chapter 12. Views, Indexes, and Sequences

This chapter covers three different yet very important database objects: views, indexes, and sequences.

Views are significant in a database because they provide row-level and column-level security to the data. They allow you to look at the data differently and/or display only specific information to the user. Views are also useful to simplify the writing of queries for end users because they can hide the complexities of joins and conditional statements.

Indexes are required for good performance of any database. A well-thought-out indexing strategy entails the careful placement of indexes on relevant columns. ...

Get Oracle® SQL by Example, Third Edition now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.