I have been reading about the table partitioning in mariadb.
I know it will not give any direct performance gains. But what about the index tables? Are they also partitioned?
Let's say a table is partioned by
user_id so all data related to one user will be in the same table partition. In a user session each query will therefore only fetch data from a single table partition
My question is: Will the index tables also be partitioned accordingly? When a query is executed it's only searching in the partitionend index table and not the entire = less indexes to search