How to Improve Performance When Adhoc Queries are Executed Frequently
There are many instances when same query is executed number of times on our database server and every time optimizer has to compile the same and create query execution plan and same is stored in cache so that it would be used next time and so. When server is heavily used and cache keeps getting …
How to Improve Performance When Adhoc Queries are Executed Frequently Read More »