Tag: indexes

Practical Tips For Moving Indexes Between Tablespaces


From time to time, a simple request to reorganize space in a tablespace leads to a more complex solution. Here’s how we moved  indexes between tablespaces.       A client requested we reduce the size of an Automatic Storage…

Read More >

Postgres partial indexes on email address domains

When I first heard of Postgres partial indexes, I knew immediately that this would have solved a problem I had in MySQL about a decade ago. That problem didn’t go unsolved, but it certainly wasn’t as easy as I’ll demonstrate…

Read More >

19c Auto-Indexing: ORA-65532: Cannot Alter or Drop Automatically Created Indexes

Hello! I recently noticed that: What if I’m not happy with the Oracle algorithm and I want to drop and auto-index on 19c? It should be easy, I initially thought. For example, something like “drop index XXXX;” right? Wrong. However,…

Read More >

Duplicate indexes in MySQL

Valerie Parham-Thompson explains why duplicate (redundant) indexes are sometimes helpful.

Read More >