Chapter 13. Indexes, Sequences, and Views

This chapter covers three different yet very important database objects: indexes, sequences, and views. Indexes are required for good performance of any database. A well-thought-out indexing strategy entails the careful placement of indexes on relevant columns. In this chapter, you will gain an understanding about the advantages and trade-offs when using indexes on tables.

Sequences generate unique values and are used mainly for creating primary key values. In this chapter, you will learn how to create and use sequences.

Views are significant in a database because they can provide row-level and column-level security ...

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

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