Originally posted by balajiyes
Hi abhaysk
In some projects we do... we rebuild the fact tables every day aft every upload.
any hint?
U certainly mean Re-org of table than saying it rebuild the table..?

Well Re-Org the table daily, u certainly are joking..


Originally posted by balajiyes
well now we hv a HUGE table with 550million rows partitioned by year month. how to go from here?
U wana Re-Org this table daily as well?
huh?

Well if it one time, then Use Alter Table Move..(I think u can do it partition wise not sure coz never used partitioned tables)

Abhay.