Thanks for your question.
If you were to upload your metadata (see this) I could assess this and give you an accurate answer.
I found this: https://getwpo.com/faqs/create-index-on-post-meta-table/
Apparently this power tweak redefines the meta_key column from VARCHAR(256) to VARCHAR(191). The article doesn’t say so, but I assume the tweak also removes the prefix index. It’s a proprietary, not open-source, function, so I can’t examine it to see exactly what it does without a metadata upload from you.
By contrast, this plugin updates the row format of the table so it is possible to index the column without using the (191) prefix index.
This plugin has a prime directive: do not redefine data columns. Users’ data is sacrosanct.
Can you use both that power tweak and this plugin? Yes, but why would you want to? The power tweak is potentially destructive.
