Uh, can't say as that makes any sense to me either.

Here is a link where we talk about indexing strategies for fact tables. Basically - lots of bitmap indexes.

It would be very rare for you to actually access facts via the PK, which should generally be your only B*Tree, and, hance, organize-able index. So, if you don't access it via that index, why organize via that index?


- Chris