When the given query/procedure is having the more number of joins or more number of case statements, the below error you will get.
To avoid this ,Tune the query as much as you can.
Reduce the number of CASE statements and run the query...
ERROR [HY000] ERROR: Memory exhausted in AllocSetAlloc()
Hope it will help you!!!
To avoid this ,Tune the query as much as you can.
Reduce the number of CASE statements and run the query...
ERROR [HY000] ERROR: Memory exhausted in AllocSetAlloc()
Hope it will help you!!!
No comments:
Post a Comment