indexes – Learning is not a spectator sport

Nulls are not stored in indexes … most of the time

This question got posed on Twitter today I answered briefly on Twitter, but I thought I should give it some

Man, it gets my goat when people start pontificating nonsense on Twitter. Yeah, I know, I know, I shouldn’t get

We had a question on AskTOM inquiring about how to handle the issue of only 8 storage indexes being possible

In a perfect world, the optimizer would reach out from the server room, say to us: “Hey, lets grab a

This one came in via an AskTOM question. You need to be careful when disabling constraints that are underpinned by

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