In this blog, we’ll cover redundant and duplicate indexes, which are quite common in applications and affect database performance. An index is duplicated when there is more than one defined on a single column. Such indexes may have varying…

How many partitions can one have in MySQL? As a DBA, you may face this question sooner or later, either as a hypothetical one or as an interesting case in a real-world scenario. What if a client dealing with a huge MySQL data warehouse has…

Databases are rather intricate systems comprising many aspects. Here, we will talk about the part that interacts with storage hardware, i.e., the storage engine. This is one of those sections that have to deal with queries, updates, transa…

While you make any changes in the system parameters or upgrade the Oracle database, you will often notice some highly regressed SQL performance or queries. In such cases, you don’t have to panic because it is quite obvious and happens with…