[Bizgres-general] A Guide to Constraint Exclusion ( Partitioning)

[Luke Lonergan]

Simon,

> SELECT
> FROM Fact, Dimension
> WHERE Fact.Key = Dimension.Key
> AND Dimension.DescriptiveField = 'Blah'

So, what happens with this:

SELECT
FROM Fact, Dimension
WHERE Fact.Key = Dimension.Key
AND Fact.part = 100;

With Fact defined with 3 partitions:
    CHECK(Part BETWEEN    1 AND 1000)
    CHECK(Part BETWEEN 1001 AND 2000)
    CHECK(Part BETWEEN 2001 AND 3000)

Will the 2nd and 3rd partitions be eliminated?

- Luke