MySQL 8.0 – Invisible Indexes February 2, 2023 Overview In this blog, we aim to discuss the new MySQL 8.0 feature: invisible indexes and how to...
Find and remove unused & duplicate indexes in MySQL January 9, 2023 Overview: It is a general rule of thumb, that the more indexes you have on a table, the slower the...
Practical Tips For Moving Indexes Between Tablespaces December 29, 2022 From time to time, a simple request to reorganize space in a tablespace leads to a more complex...
Duplication: divide et impera September 19, 2013 For me, every Monday morning starts with the same routine. I refresh some QA databases from...
Build an 11gR2 RAC Cluster in VirtualBox in 1 Hour Using OVM Templates December 21, 2012 After reviewing my blog post about running EBS OVM templates in VirtualBox, two of my teammates...