File tree Expand file tree Collapse file tree 3 files changed +4
-0
lines changed Expand file tree Collapse file tree 3 files changed +4
-0
lines changed Original file line number Diff line number Diff line change @@ -325,6 +325,7 @@ VALUES ('aardvark'),
325
325
('aba'),
326
326
('ABC'),
327
327
('abd');
328
+ CREATE INDEX srt_name ON srt (name);
328
329
-- Check the min() and max() aggregates, with and without index.
329
330
set enable_seqscan = off;
330
331
SELECT MIN(name) AS "AAA" FROM srt;
Original file line number Diff line number Diff line change @@ -325,6 +325,7 @@ VALUES ('aardvark'),
325
325
('aba'),
326
326
('ABC'),
327
327
('abd');
328
+ CREATE INDEX srt_name ON srt (name);
328
329
-- Check the min() and max() aggregates, with and without index.
329
330
set enable_seqscan = off;
330
331
SELECT MIN(name) AS "AAA" FROM srt;
Original file line number Diff line number Diff line change @@ -127,6 +127,8 @@ VALUES ('aardvark'),
127
127
(' ABC' ),
128
128
(' abd' );
129
129
130
+ CREATE INDEX srt_name ON srt (name);
131
+
130
132
-- Check the min() and max() aggregates, with and without index.
131
133
set enable_seqscan = off;
132
134
SELECT MIN (name) AS " AAA" FROM srt;
You can’t perform that action at this time.
0 commit comments