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...
Parallelizing Index Creation
Implementing Bitmap Indexes- Tables and Constraints
Bitmap indexes are recommended for columns with a relatively low degree of distinct values (low cardinality). You should not use...
Creating Indexes- Tables and Constraints
As described previously, when you think about creating tables, you must think about the corresponding index architecture. Creating the appropriate...
Reactively Creating Indexes- Tables and Constraints
Rarely do DBAs and developers accurately create the right mix of indexes when first deploying an application. And that is...
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...
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...
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...
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...
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...
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...