August 2009
Intermediate to advanced
960 pages
21h 21m
English
Content preview from Oracle SQL By Example Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
Start your free trial
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 ...