partitioning – Page 2 – Learning is not a spectator sport

The phantom tablespace

(Cueing my deep baritone Morpheus voice…) What if I told you that you can reference non-existent tablespaces in your DDL?

One of the nice things about partitioning in the database is that partition pruning can quickly eliminate the requirement to

Partial indexes are a very cool feature that came along with Oracle 12c. The capability at partition level to control

Just a quick post to clear up some confusion that can be seen on the partial indexing capabilities in Oracle

As you can tell, I have no idea on a name for what I am about to describe. So let

Sometimes in the IT world, the term “surprise” is not a good one. “I woke up this morning and got

One of the cool things in 18c is the ability to merge partitions without causing a service interruption. Here’s a

I love Active Session History (ASH) data because a lot of the work I’ve done in my consulting life was

So just what is a “partition-wise” join ? We will use a metaphor to hopefully explain the benefit. Let’s say

An index is basically a structure that maps keys (values) in columns to the physical location of their corresponding rows