what's your opinion/experience about star transformation?

Does Oracle im most case take the right decision to either access the fact table via full table scan or rowid (TABLE ACCESS BY LOCAL INDEX ROWID) ?