Chapter 21
Creating Additional Structural Elements
Abstract
This chapter discusses the creation and use of SQL to manage database elements not covered in previous chapters. Topics include views, temporary tables, common table expressions, and indexes. The discussion of temporary tables covers creating the tables, loading them with data, and disposing of them when they are no longer needed. The chapter not only looks at how to create views, but also includes a discussion of deciding which views are needed.
Keywords
SQL
SQL views
SQL temporary tables
SQL common table expressions
CTEs
SQL CTEs
SQL indexes
CREATE INDEX
Views
As you first read in Chapter 5, views provide a way to give users a specific portion of a larger schema with which they can work. ...
Get Relational Database Design and Implementation, 4th Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
