Managing a big table
607100Dec 15 2009 — edited Dec 16 2009Hi All,
I have a big table in my database. When I say big, it is related to data stored in it (around 70 million recs) and also no of columns (425).
I do not have any problems with it now, but going ahead I assume, it would be a bottleneck or very difficult to manage this table.
I have a star schema for the application of which this is a master table.
Apart from partitioning the table is there any other way of better handling such a table.
Regards