Star Transformation does not work with common table expressions

I have a query such as the following

WITH A as
( select ... from FACT, DIM1, DIM2

where FACT.DKEY1=DIM1.DKEY1 and FACT.DKEY2=DIM2.DKEY2 and DIM1.COL1='A' and DIM2.COL1='B')
select * from A

This never uses the star transform. However, the same query written as

select * from
( select ... from FACT, DIM1, DIM2

where FACT.DKEY1=DIM1.DKEY1 and FACT.DKEY2=DIM2.DKEY2 and DIM1.COL1='A' and DIM2.COL1='B')

does use the star transform. Are there any known restrictions on using the star transformation in a common table expression Received on Wed Jan 18 2006 - 01:03:59 CST