Planning for Robustness – Oracle Database

19/07/2024

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...

19/04/2024

When you create a B-tree index, you can also specify that the index be unique. Doing so ensures that non-NULL...

19/12/2023

For critical applications, you must give some thought to how much space tables and indexes will consume and how fast...

19/09/2023

Rarely do DBAs and developers accurately create the right mix of indexes when first deploying an application. And that is...

18/05/2023

A check constraint works well for lookups when you have a short list of fairly static values, such as a...

18/02/2023

When you implement a database, most tables you create require a primary key constraint to guarantee that every record in...

18/10/2022

Every row in every table has an address. The address of a row is determined from a combination of the...

18/09/2022

You can use either the DELETE statement or the TRUNCATE statement to remove records from a table. A DELETE statement...

18/06/2022

There are a couple of reasons to rename a column. Sometimes, requirements change, and you may want to modify the...

18/03/2022

When you are creating a table, you have the option of specifying the NOLOGGING clause. The NOLOGGING feature can greatly...