Taking Control of Your SQL Performance
See how to use a Frozen Query Plans to save—or freeze—the execution plan for your queries and get the most from your queries.
If you run Tune Table, for example, you would expect your Query Plans to change on some queries. However, with frozen Query Plans, your queries won't change until you want them to!
In this webinar, InterSystems Senior Support Specialist Kyle Baxter takes you on a tour of frozen Query Plans and teaches you how to ensure upgrades never degrade your query performance. The following topics are covered:
- How to freeze Query Plans to solve query performance issues before they happen
- How to use frozen plans to upgrade code with confidence
- How to use frozen plans to quickly resolve unexpected SQL problems