Check if there is a better way of writing an equivalent query.
What if the queries are done dynamically using PREPARE STATMENT like that. Right now iam looking at the WAREHOUSING sub-system & its PLANs.
Suggesting MQT's are on my list.
What are the other things i need to look in WAREHOUSING kind of scenarios.