partitioning will help u Krishna
On Fri, Jan 14, 2011 at 4:18 AM, Sairam Krishnamurthy <kmsram...@gmail.com>wrote: > All, > > 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. > > -- > Thanks, > Sairam Krishnamurthy > +1 612 859 8161 > >