Author Archives: Oren Nakdimon

Constraint Optimization Summary

Oren Nakdimon Leave a Reply

This is the last part of a series about Constraint Optimization. In this post I’ll summarize the conclusions from the previous parts. When we add a constraint to an existing table, there are two aspects that are worth taking into consideration: duration and availability. Duration When the table contains a significant number of rows, adding […]

Continue reading

Fast but Offline, or Online but Slow?

Oren Nakdimon Leave a Reply

The Constraint Optimization series: Part 1: Optimization of Check Constraint Creation Part 2: Optimization that Violates Data Integrity Part 3: Optimization of Foreign Key Constraint Creation Part 4: (Lack of) Optimization of Unique Constraint Creation Part 5: Adding a Column with a Default Value and a Constraint Part 6: Fast but Offline, or Online but […]

Continue reading

EBR – Part 1: Overview and Setup

Oren Nakdimon Leave a Reply

This is a link to an index page for all the parts of the series I have been using EBR in a real production system for more than 4 years now. EBR – an acronym for Edition-Based Redefinition – is a powerful and unique feature (or, more precisely, a set of features) that enables patching […]

Continue reading

ODC Appreciation Day: Collections in SQL

Oren Nakdimon Leave a Reply

Here’s my contribution to the ODC Appreciation Day. Overview Last week I had the privilege to participate in the EOUC Database ACES Share Their Favorite Database Things session at Oracle OpenWorld, so I think that the best topic to write about, as part of the ODC Appreciation Day, is the one I talked about in […]

Continue reading

RETURNING INTO – Enhancement Suggestion

Oren Nakdimon 3 Replies

The RETURNING INTO clause is one of my favorite features. It returns data from the rows that have been affected by the DML statement, and as I wrote in this previous post: For INSERT it returns the after-insert values of the new row’s columns. For UPDATE it returns the after-update values of the affected rows’ […]

Continue reading