Chapter 5. Creating and Managing Schema Objects
Only undertake what you can do in an excellent fashion. There are no prizes for average performance. - Brian Tracy
In this chapter we will discuss various schema objects such as tables, indexes, and views. We will also learn how to create, modify, and drop schema objects using the CREATE, ALTER, and DROP statements. At the end of this chapter, we will discuss the importance of object statistics and how to gather statistics. The topics that will be covered in this chapter are as follows:
Data Definition Language
Creating and managing tables
Creating and managing indexes
Integrity constraints
Creating and managing views
Creating and managing synonyms
Creating and managing sequences
Gathering statistics
Data Definition Language
Statements that create, modify, or change schema objects are termed as Data Definition Language (DDL) statements. The CREATE, ALTER, and DROP statements are examples of DDL statements. We create a new schema object using the CREATE...
