August 2026

Monochrome image of three vintage alarm clocks highlighting the passage of time.

DML WAIT[NOWAIT] in Oracle AI Database 26ai

Leave a Comment / 23c/26ai New Features, Daily DBA Stuff / /

Introduction DML WAIT[NOWAIT], introduced in 23.26.2.0.0, helps to specify how long a DML statement should wait to acquire a lock before rolling back the DML statement and returning session control to the user. The general syntax is: You can specify whether to wait forever, not at all or for n seconds, milliseconds or microseconds. The […]

DML WAIT[NOWAIT] in Oracle AI Database 26ai Read More »

note box, index box, index, index cards, filing, office, archive, drawer, wardrobe

Importance of Indexing Foreign Key Columns

Leave a Comment / Daily DBA Stuff / /

Introduction In a relational database, defining constraints can help ensure data integrity, improve data consistency, enhance SQL query performance, and, in the case of foreign keys, ensure referential integrity. I talk a lot more about constraints in a previous post about database constraints. In a separate post, I also talk about locks and transaction concurrency

Importance of Indexing Foreign Key Columns Read More »