Tom Jewett's "Database Design with UML and SQL: SQL Technique: Views and Indexes"

Read this page for an overview of views and indexes in SQL.