Monster Dimension

View previous topic View next topic Go down

Monster Dimension

Post  eshtee on Thu Jul 28, 2011 12:19 am

Hello All,
I have a monster customer dimension. around 50 million records in the initial load and a million record updates and new records daily. how should i manage it and make it more efficient. can table partitioning help me in this scenario like for fact tables? should i be dropping indexes before load and recreating them?
Really appreciate your help.

Thanks,
Syed

eshtee

Posts : 6
Join date : 2011-07-19

View user profile

Back to top Go down

Re: Monster Dimension

Post  hang on Thu Jul 28, 2011 1:02 am


hang

Posts : 528
Join date : 2010-05-07
Location : Brisbane, Australia

View user profile

Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum