Skip to content

Commit 9f18e33

Browse files
committed
example update
1 parent 7ef601a commit 9f18e33

File tree

1 file changed

+0
-4
lines changed

1 file changed

+0
-4
lines changed

optimizer/spm_fix/example.sql

Lines changed: 0 additions & 4 deletions
Original file line numberDiff line numberDiff line change
@@ -15,10 +15,6 @@ connect spmdemo/spmdemo
1515
-- Run the testq1 multiple times and capture in AWR
1616
-- Assuming a SQL Disagnostics Pack licence.
1717
--
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-
--
2218
@@q1many
2319
--
2420
-- Induce a bad plan for Q1 by dropping the histograms

0 commit comments

Comments
 (0)