Skip navigation.

Richard Foote

Syndicate content Richard Foote's Oracle Blog
Focusing Specifically On Oracle Indexes, Database Administration and Some Great Music
Updated: 8 hours 11 min ago

Indexing Foreign Keys (Helden)

Wed, 2014-04-02 00:41
A recent question on an internal forum asked whether an index on a Foreign Key (FK) constraint designed to avoid locking issues associated with deletes on the parent tables needs to precisely match the columns in the FK. Could the columns in the index potentially be a different order or be appended with additional columns ? The answer is […]
Categories: DBA Blogs

Index Rebuild, the Need vs the Implications Support Note 989093.1 (Getting Better)

Tue, 2014-03-04 23:49
Once upon a time, Oracle Support had a note called Script: Lists All Indexes that Benefit from a Rebuild (Doc ID 122008.1) which lets just say I didn’t view in a particularly positive light :) Mainly because it gave dubious advice which included that indexes should be rebuilt if: Deleted entries represent 20% or more of […]
Categories: DBA Blogs

Modify Primary Key Using Index (Learning To Fly)

Thu, 2014-02-27 00:34
One of the things I love about working with Oracle Database technologies is that there’s just so much one can learn. I make it an active goal of mine to try to learn something new at work each and every day, no matter how big or small. One of these days, I might blog about a presentation I put together […]
Categories: DBA Blogs

12c Enhanced Online Index DDL Operations (Lady Godiva’s Operation)

Mon, 2014-02-17 00:41
In my last couple of posts, I discussed how table partitions can be moved online since 12c, keeping all indexes in sync as part of the process. 12c also introduced enhancements to a number of index related DDL statements, removing blocking locks and making their use online and far less intrusive. The following commands now have a new ONLINE […]
Categories: DBA Blogs

12c Online Partitioned Table Reorganisation Part II (Move On)

Tue, 2014-01-14 23:06
In Part I, we looked at some of the issues associated with locking and unusable indexes when Moving both tables and table partitions. The Oracle 12c Database has introduced a number of great new capabilities associated with online DDL activities. One of these really useful features is the capability to now move table partitions online while […]
Categories: DBA Blogs

12c Online Partitioned Table Reorganisation Part I (Prelude)

Mon, 2014-01-06 22:07
First post for 2014 !! Although it’s generally not an overly common activity with Oracle databases, reorganising a table can be somewhat painful, primarily because of the associated locking implications and the impact it has on indexes. If we look at the following example: So we have a table with a couple of indexes. We […]
Categories: DBA Blogs

Demo Links To All Older Posts Now Accessible (Chains)

Thu, 2014-01-02 22:05
OK, for a quite some time (too long probably !!!) people have been sending me emails and leaving comments that they have been unable to access a number of the demos to my older posts and those listed in my Presentations and Demos page. I previously would write an article but include a demo that […]
Categories: DBA Blogs