Fact Records/Oracle/Indexes

[srokes]

Does anybody have billions of rows in a fact table?
Does anybody have billions of rows in a fact table and using oracle?

 

[MDXer]

I have worked a project in the past that had In excess of 4 billion Rows. THe platform was MS SQL Server.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[srokes]

But was that in one table?

 

[MDXer]

No the data was partitioned along time with each period living in it's own fact table. The data was then built into cubes along our partitioning strategy. I don't know I would ever design something with billions of rows in a single table. If I had knowledge of the expected data size at design time I would put serious consideration into partitioning strategies for the data.

Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[srokes]

Yes, we will be partitioning the data along monthly processing date. But the over all table will have billions of rows and each partition will have 100 to 200 hundred milliion rows per month. I am wondering about a table and not each partition.