We read every piece of feedback, and take your input very seriously.
To see all available qualifiers, see our documentation.
There was an error while loading. Please reload this page.
1 parent 7ef601a commit 9f18e33Copy full SHA for 9f18e33
optimizer/spm_fix/example.sql
@@ -15,10 +15,6 @@ connect spmdemo/spmdemo
15
-- Run the testq1 multiple times and capture in AWR
16
-- Assuming a SQL Disagnostics Pack licence.
17
--
18
--- We could also load Q1 into a SQL Tuning Set because
19
--- this source is also searched by SPM for previous plans.
20
--- SQL tuning sets required a SQL Tuning Pack licence.
21
---
22
@@q1many
23
24
-- Induce a bad plan for Q1 by dropping the histograms
0 commit comments