Good afternoon,
We have an ADSO with static Partitioning by dimensión 0FISCYEAR
there is a query that reads data from this ADSO we usually get data from 2023 to the current year, the execution time is about 6 seconds
After seting the partion 2023 to the cold store we try to execute the query but we only get a timeout, we cannot execute the query with the same filters.
Is it normal that the performance deteriorates so badly? is there anyway to improve this performance?
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.