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

We had an AskTOM question recently about being able to search for numbers within a concatenated list. The particular issue

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

If you’re appropriately licensed and want to use advanced index compression, you can take advantage of the setting a tablespace