|
Hi All ,
We are thinking of converting one of huge
table in to partition table . What is best way to achieve this ? Is there
any alter table clause that can do this or I will have to export ..recreate
table with partition option and then import . Also how can I mentiod that
partition should have only 100000 rows . For example after each 100000 rows add
another partition ?
If I have 10000000 rows in the table , should I
expect some performance gain out of this
Thanks ,
BigP
|
- RE: partition tables BigP
- RE: partition tables Khedr, Waleed
- Re:RE: partition tables dgoulet
- Re:RE: partition tables Rachel Carmichael
- Re: partition tables paquette stephane
- RE: partition tables DENNIS WILLIAMS
- Re: partition tables Steven Lembark
- RE: partition tables Jack Silvey
- RE: partition tables Ron Rogers
- RE: RE: partition tables Michael P Sale
- RE: partition tables Cherie_Machler
