0
votes
1answer
319 views

~2 Billion row fact table in star schema on Oracle. Advisable? [closed]

Let me start with: I am not a DBA; I am a backend developer. It has been suggested that, for a report schema, I implement a star schema where-in the fact table can have ~2B rows before being ...
5
votes
2answers
689 views

Cardinality rule for bitmap indexes

The Oracle documentation includes the following advice: A bitmap index should be built on each of the foreign key columns of the fact table or tables In that reference, there is even a bitmap ...