High database load by indexer-cron

[p24-max]

Having the latest version 2.4.2 installed on magento 2.4.5-p5, I noticed an highly increased database load which is caused by the magento-cronjob.
I investigated and figured out that a high amount of database tables is created and dropped compared to not having this module installed:
Query: SHOW GLOBAL STATUS;

As a hotfix, I changed the indexer "Smart Category Product Rule" to "UPDATE ON SAVE" which reduces the load a bit.