Deciding When to Create an Index- Indexes
There are usually two different situations in which DBAs and developers decide to create indexes: Proactively Creating Indexes When creating...
George Vest
Enabling Constraints- Tables and Constraints
This section contains a few scripts to help you enable constraints that you’ve disabled. Listed next is a script that...
Disabling Constraints- Tables and Constraints
One nice feature of Oracle is that you can disable and enable constraints without dropping and re-creating them. This means...
Checking for Specific Data Conditions- Tables and Constraints
A check constraint works well for lookups when you have a short list of fairly static values, such as a...
Creating Foreign Key Constraints- Tables and Constraints
Foreign key constraints are used to ensure that a column value is contained within a defined list of values. Using...
Enforcing Unique Key Values- Tables and Constraints
In addition to creating a primary key constraint, you should create unique constraints on any combinations of columns that should...
Creating Primary Key Constraints- Tables and Constraints
When you implement a database, most tables you create require a primary key constraint to guarantee that every record in...
Creating an Index-Organized Table- Tables and Constraints
Index-organized tables (IOTs) are efficient objects when the table data is typically accessed through querying on the primary key. Use...
Temporary Table Redo- Tables and Constraints
No redo data are generated for changes to blocks of a global temporary table. However, rollback (undo) data is generated...
Creating a Temporary Table Global Temporary Table- Tables and Constraints
Use the CREATE GLOBAL TEMPORARY TABLE statement to create a table that stores data only provisionally. You can specify that...