Skip to Content
0
Jun 05, 2020 at 02:33 PM

What aspects should be analyzed when SQL query takes more memory than usual? (HANA SPS12)

102 Views

Hello,

We sometimes face a scenario where a query which normally runs smoothly taking 10GB memory.
The same query (without any change) scheduled at the same time takes 700 GB.
What aspects should be looked for in such scenario ?

Thanks,

Prathamesh H.