DISABLE_JOIN_PRUNER (SELECT Option)

DISABLE_JOIN_PRUNER

Note: When SELECT options are specified as part of a subquery or subselect, they might not affect the root-level query execution plan.

Operator

SELECT

Syntax

disable_join_pruner

Example

SELECT { option DISABLE_JOIN_PRUNER="false" }

t1.*

from /shared/"myquery"/testdb/my_product t1 inner join

/shared/"myquery"/testdb/products t2

on t2.productid = t1.productid

Relationship: my_product.productid is the foreign key for products.productidprimary key.

Result:

The PK table will participate in pruning. The resolved SQL is:

SELECT "t1"."categoryid","t1"."categoryname","t1"."productid","t1"."supplierid"
FROM "tutorial"."my_product" "t1"