indexes – Learning is not a spectator sport

Exadata storage indexes

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