partitioning will help u
On Fri, Jan 14, 2011 at 4:18 AM, Sairam Krishnamurthy
> I have a very large table. It has about 1 billion rows. Initially
> everything was fine. But now the table is a bit slow. Loaded takes a lot of
> time. I usually load in chunks of 22 million rows.
> Is the size of the table any way related to the performance? I am not sure
> about this.
> Will splitting the table and having a "view" from multiple table increase
> the performance?
> Thanks in advance.
> Sairam Krishnamurthy
> +1 612 859 8161