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
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
