O'Reilly logo

Oracle® SQL by Example, Third Edition by Alice Rischert

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required