...................678 SPI_is_cursor_plan .....................................................................................................679 SPI_execute_plan..................................... HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses may be reorganized in any manner allowed partition from the query plan. You can use the EXPLAIN command to show the difference between a plan with constraint_exclusion on and a plan with it off. A typical default plan for this type of table setup

............................................................................ 541 15.3.5. Parallel Plan Tips .................................................................................. 542 15.4. HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's possible to show the difference between a plan for which partitions have been

...................682 SPI_is_cursor_plan .....................................................................................................683 SPI_execute_plan..................................... HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses may be reorganized in any manner allowed partition from the query plan. You can use the EXPLAIN command to show the difference between a plan with constraint_exclusion on and a plan with it off. A typical default plan for this type of table setup

............................................................................ 513 15.3.5. Parallel Plan Tips ............................................................................ 513 15.4. Parallel HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's pos- sible to show the difference between a plan for which partitions have been

...................635 SPI_is_cursor_plan .....................................................................................................636 SPI_execute_plan..................................... HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses may be reorganized in any manner allowed row structure must be specified in the query itself, so that the system can know how to parse and plan the query. Consider this example: SELECT * FROM dblink(’dbname=mydb’, ’select proname, prosrc from

......................600 SPI_is_cursor_plan ..............................................................................................601 SPI_execute_plan......................................... HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses may be reorganized in any manner allowed row structure must be specified in the query itself, so that the system can know how to parse and plan the query. Consider this example: SELECT * FROM dblink(’dbname=mydb’, ’select proname, prosrc from

............................................................................ 527 15.3.5. Parallel Plan Tips .................................................................................. 528 15.4. HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's possible to show the difference between a plan for which partitions have been

............................................................................ 499 15.3.5. Parallel Plan Tips ............................................................................ 499 15.4. Parallel HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions 54 SQL Syntax (AND/OR/NOT combinations) in those clauses can be reorganized the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's pos- sible to show the difference between a plan for which partitions have been

............................................................................ 495 15.3.5. Parallel Plan Tips ............................................................................ 495 15.4. Parallel HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's pos- sible to show the difference between a plan for which partitions have been

............................................................................ 522 15.3.5. Parallel Plan Tips .................................................................................. 523 15.4. HAVING clauses, since those clauses are extensively reprocessed as part of developing an execution plan. Boolean expressions (AND/OR/NOT combinations) in those clauses can be reorganized in any manner allowed the partition from the query plan. By using the EXPLAIN command and the enable_partition_pruning configuration parameter, it's possible to show the difference between a plan for which partitions have been