Parallelizing Index Creation- Tables and Constraints
In large database environments in which you are attempting to create an index on a table that is populated with...
Temporary Table Redo
Creating Multiple Indexes on the Same Set of Columns- Tables and Constraints
Multiple indexes can be on the same set of columns, but there must be something physically different about the index....
Estimating the Size of an Index Before Creation- Tables and Constraints
If you do not work with large databases, then you do not need to worry about estimating the amount of...
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...
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...
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...
Removing Data from a Table- Tables and Constraints
You can use either the DELETE statement or the TRUNCATE statement to remove records from a table. A DELETE statement...
Dropping a Table- Tables and Constraints
If you want to remove an object, such as a table, from a user, use the DROP TABLE statement. This...