Table Partioning

[abhijeet364]

Hi ,

Guru's need a help. We are using Oracle as our DB. Current our ETL team is performing table partioning on the fact table's to do performance improvement. So just wanted to know whether this would affect the report's which are using this table.

Regards,
Abhijeet

[abhijeet364]

Hi Techies,

Looking for your help. Its very urgent..

Regards
Abhijeet

[MFGF]

Why not create a dummy table, build a report on it, partition the table and see if your report still works - this would answer your question. If it's as urgent as you imply, it would seem to be a quick, easy way to resolve the urgency.

[blom0344]

Partitioning is no magic wand. If - for example - you partition on year and most reports will use temporal selectivity than performance may improve dramatically since only part of the data will have to accessed.  However , other type of selectivity may negate the partitioning since all data will need to be scanned..

The proof is in the pudding   ;D

[wyconian]

Hi

I think the changes made in the database need to be reflected in the FM model as well.  For example  if your DB guys have added a partiton key (a column used to identify which partition a record should be placed in) you may  need to add that into part of the relationships into the fact.