| -- start_matchignore |
| -- m/^LOG.*Missing statistics for column.*/ |
| -- end_matchignore |
| -- Test Optimizer Plan Hints Feature |
| -- |
| -- Purpose: Test that plan hints may be used to coerce the plan shape generated |
| -- by the optimizer. |
| |
| LOAD 'pg_hint_plan'; |
| |
| DROP SCHEMA IF EXISTS planhints CASCADE; |
| |
| CREATE SCHEMA planhints; |
| SET search_path=planhints; |
| SET optimizer_trace_fallback=on; |
| |
| -- Setup tables |
| CREATE TABLE my_table(a int, b int); |
| CREATE INDEX my_awesome_index ON my_table(a); |
| CREATE INDEX my_amazing_index ON my_table(a); |
| CREATE INDEX my_incredible_index ON my_table(a); |
| CREATE INDEX my_bitmap_index ON my_table USING bitmap (a); |
| |
| CREATE TABLE your_table(a int, b int) WITH (appendonly=true); |
| CREATE INDEX your_awesome_index ON your_table(a); |
| CREATE INDEX your_amazing_index ON your_table(a); |
| CREATE INDEX your_incredible_index ON your_table(a); |
| CREATE INDEX your_bitmap_index ON your_table USING bitmap (a); |
| |
| CREATE TABLE our_table(a int, b int) PARTITION BY RANGE (a) (PARTITION p1 START(0) END(10) EVERY(3)); |
| CREATE INDEX our_awesome_index ON our_table(a); |
| CREATE INDEX our_amazing_index ON our_table(a); |
| CREATE INDEX our_incredible_index ON our_table(a); |
| CREATE INDEX our_bitmap_index ON our_table USING bitmap (a); |
| |
| ANALYZE my_table; |
| ANALYZE your_table; |
| ANALYZE our_table; |
| |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 1. [JOIN] Specific explicit scan type and implicit/explicit index |
| -- |
| -------------------------------------------------------------------- |
| |
| SET client_min_messages TO log; |
| SET pg_hint_plan.debug_print TO ON; |
| |
| -- Replace timestamp while logging with static string |
| -- start_matchsubs |
| -- m/[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}:[0-9]{6} [A-Z]{3}/ |
| -- s/[0-9]{4}-[0-9]{2}-[0-9]{2} [0-9]{2}:[0-9]{2}:[0-9]{2}:[0-9]{6} [A-Z]{3}/YYYY-MM-DD HH:MM:SS:MSMSMS TMZ/ |
| -- end_matchsubs |
| /*+ |
| SeqScan(t1) |
| SeqScan(t2) |
| SeqScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan |
| /*+ |
| IndexScan(t1 my_incredible_index) |
| IndexScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| /*+ |
| IndexScan(t1) |
| IndexScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| IndexOnlyScan(t1 my_incredible_index) |
| IndexOnlyScan(t2 your_amazing_index) |
| IndexOnlyScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| IndexOnlyScan(t1) |
| IndexOnlyScan(t2) |
| IndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| BitmapScan(t1 my_bitmap_index) |
| BitmapScan(t2 your_bitmap_index) |
| BitmapScan(t3 our_bitmap_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| BitmapScan(t1) |
| BitmapScan(t2) |
| BitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 2. [SCAN] Specific explicit scan type and implicit/explicit index |
| -- |
| -------------------------------------------------------------------- |
| |
| /*+ |
| SeqScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| SeqScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| SeqScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| IndexScan(t1 my_incredible_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| IndexScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| --/*+ |
| -- IndexScan(t2 your_amazing_index) |
| -- */ |
| --EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| --/*+ |
| -- IndexScan(t2) |
| -- */ |
| --EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| IndexScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| IndexScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| IndexOnlyScan(t1 my_incredible_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| IndexOnlyScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| -- CBDB_MERGE_FIXME: ao/aocs table not suport IndexOnlyScan in PG Optimizer(ORCA support it) |
| -- after we cherry-pick 74246e48ed(Enable index only scan on ao/aocs table) |
| -- So current case will generate a scan seq(also other IndexOnlyScan(your_table) will). |
| -- See more details in indxpath.c:L817, The logic is: |
| -- |
| -- if (!AMHandlerIsAO(rel->amhandler) || |
| -- index->amcostestimate == bmcostestimate) |
| -- add_path(rel, (Path *) ipath, root); |
| /*+ |
| IndexOnlyScan(t2 your_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| IndexOnlyScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| IndexOnlyScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| IndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| BitmapScan(t1 my_bitmap_index) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| BitmapScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| BitmapScan(t2 your_bitmap_index) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| BitmapScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| BitmapScan(t3 our_bitmap_index) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| /*+ |
| BitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 3. [JOIN] No scan type |
| -- |
| -------------------------------------------------------------------- |
| |
| /*+ |
| NoSeqScan(t1) |
| NoSeqScan(t2) |
| NoSeqScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| NoIndexScan(t1) |
| NoIndexScan(t2) |
| NoIndexScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| NoIndexOnlyScan(t1) |
| NoIndexOnlyScan(t2) |
| NoIndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| NoBitmapScan(t1) |
| NoBitmapScan(t2) |
| NoBitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t2.a, t3.a FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 4. [SCAN] No scan type |
| -- |
| -- Note that pg_hint_plan does not support multiple No.*Scan hints, so the |
| -- parser will generate warnings indicating conflicting hints. |
| -- |
| -------------------------------------------------------------------- |
| |
| -- |
| -- Make SeqScan is only valid plan |
| -- |
| /*+ |
| NoIndexScan(t1) |
| NoIndexOnlyScan(t1) |
| NoBitmapScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| NoIndexScan(t2) |
| NoIndexOnlyScan(t2) |
| NoBitmapScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| NoIndexScan(t3) |
| NoIndexOnlyScan(t3) |
| NoBitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| -- |
| -- Make IndexScan is only valid plan |
| -- |
| /*+ |
| NoSeqScan(t1) |
| NoIndexOnlyScan(t1) |
| NoBitmapScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| NoSeqScan(t2) |
| NoIndexOnlyScan(t2) |
| NoBitmapScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| NoSeqScan(t3) |
| NoIndexOnlyScan(t3) |
| NoBitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| -- |
| -- Make IndexOnlyScan is only valid plan |
| -- |
| /*+ |
| NoSeqScan(t1) |
| NoIndexScan(t1) |
| NoBitmapScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| NoSeqScan(t2) |
| NoIndexScan(t2) |
| NoBitmapScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| NoSeqScan(t3) |
| NoIndexScan(t3) |
| NoBitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| -- |
| -- Make BitmapScan is only valid plan |
| -- |
| /*+ |
| NoSeqScan(t1) |
| NoIndexScan(t1) |
| NoIndexOnlyScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| NoSeqScan(t2) |
| NoIndexScan(t2) |
| NoIndexOnlyScan(t2) |
| */ |
| EXPLAIN (costs off) SELECT t2.a FROM your_table AS t2 WHERE t2.a<42; |
| |
| /*+ |
| NoSeqScan(t3) |
| NoIndexScan(t3) |
| NoIndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT t3.a FROM our_table AS t3 WHERE t3.a<42; |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 5. [VIEWS] Specific explicit scan type and implicit/explicit index |
| -- |
| -------------------------------------------------------------------- |
| |
| CREATE VIEW everybody_view AS SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a WHERE t1.a<42; |
| |
| /*+ |
| SeqScan(t1) |
| SeqScan(t2) |
| SeqScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| /*+ |
| IndexScan(t1 my_incredible_index) |
| IndexScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| /*+ |
| IndexScan(t1) |
| IndexScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| /*+ |
| IndexOnlyScan(t1 my_incredible_index) |
| IndexOnlyScan(t2 your_amazing_index) |
| IndexOnlyScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| /*+ |
| IndexOnlyScan(t1) |
| IndexOnlyScan(t2) |
| IndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| /*+ |
| BitmapScan(t1 my_bitmap_index) |
| BitmapScan(t2 your_bitmap_index) |
| BitmapScan(t3 our_bitmap_index) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| /*+ |
| BitmapScan(t1) |
| BitmapScan(t2) |
| BitmapScan(t3) |
| */ |
| EXPLAIN (costs off) SELECT * FROM everybody_view; |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 6. [CTE] Specific explicit scan type and implicit/explicit index |
| -- |
| -------------------------------------------------------------------- |
| |
| /*+ |
| SeqScan(t1) |
| SeqScan(t2) |
| SeqScan(t3) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| /*+ |
| IndexScan(t1 my_incredible_index) |
| IndexScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| -- NB: IndexScan on AO table is invalid because AO tables do not support index |
| -- scan (e.g. t2) |
| /*+ |
| IndexScan(t1) |
| IndexScan(t3) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| /*+ |
| IndexOnlyScan(t1 my_incredible_index) |
| IndexOnlyScan(t2 your_amazing_index) |
| IndexOnlyScan(t3 our_amazing_index) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| /*+ |
| IndexOnlyScan(t1) |
| IndexOnlyScan(t2) |
| IndexOnlyScan(t3) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| /*+ |
| BitmapScan(t1 my_bitmap_index) |
| BitmapScan(t2 your_bitmap_index) |
| BitmapScan(t3 our_bitmap_index) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| /*+ |
| BitmapScan(t1) |
| BitmapScan(t2) |
| BitmapScan(t3) |
| */ |
| EXPLAIN (costs off) WITH cte AS |
| ( |
| SELECT t1.a AS a1, t2.a AS a2, t3.a AS a3 FROM my_table AS t1 JOIN your_table AS t2 ON t1.a=t2.a JOIN our_table AS t3 ON t3.a=t2.a |
| ) |
| SELECT a1, a2, a3 FROM cte WHERE a1<42; |
| |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 7. Unsupported hints |
| -- |
| -------------------------------------------------------------------- |
| |
| /*+ |
| TidScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.ctid FROM my_table AS t1 WHERE ctid = '(0,1)'; |
| |
| /*+ |
| NoTidScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.ctid FROM my_table AS t1 WHERE ctid >= '(0,1)'; |
| |
| /*+ |
| IndexScanRegexp(t1 '*awesome*') |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| IndexOnlyScanRegexp(t1 '*awesome*') |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| /*+ |
| BitmapScanRegexp(t1 '*awesome*') |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| |
| -------------------------------------------------------------------- |
| -- |
| -- 8. Miscellaneous cases |
| -- |
| -------------------------------------------------------------------- |
| |
| -- Missing hint relation name argument |
| /*+ |
| SeqScan() |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| -- Mixing NoIndexScan and SeqScan hints |
| /*+ |
| SeqScan(t1) NoIndexScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| /*+ |
| NoIndexScan(t1) SeqScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| -- Scan Hints with Semi/Anti Semi Joins |
| /*+ |
| SeqScan(t2) SeqScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t1.b FROM my_table AS t1 WHERE EXISTS (SELECT 1 FROM your_table AS t2 WHERE t1.a = t2.a); |
| /*+ |
| SeqScan(t2) SeqScan(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a, t1.b FROM my_table AS t1 WHERE NOT EXISTS (SELECT 1 FROM your_table AS t2 WHERE t1.a = t2.a); |
| -- Missing alias in query to test Un-used Hint logging |
| /*+ |
| NoIndexScan(z) SeqScan(y) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| -- Invalid Scan type to test Hint logging behavior |
| /*+ |
| NoBitmap(t1) |
| */ |
| EXPLAIN (costs off) SELECT t1.a FROM my_table AS t1 WHERE t1.a<42; |
| |
| RESET client_min_messages; |
| RESET pg_hint_plan.debug_print; |
