Search SSWUG.ORG:

DATABASES

Creating a SQL Plan Baseline out of a modified SQL This is an off-site link.  Please review our Terms of Service for additional information.




(Carlos Sierra) While delivering a session at KSCOPE 14, I was asked a very good question: Can I create a SQL Plan Baseline for an Original SQL out of a Modified SQL? In other words, query Q1, which performs poorly, has SQL_ID1 and SQL_HANDLE1 with a poorly performing Execution Plan with Hash Value PHV1

Read this article...







comments powered by Disqus