Questions regarding table partitioning
Posted on 2009-02-10
1- how do I partition a table that already exists and is not pratitioned
2- if a table is partitioned , for example, each year sits in its own partition, when a new year occurs, will Oracle create the new partition automatically?
3- If I want to search for a date range that spans two or more partitions, does Oracle handle this for me by my use of the WHERE in a SELECT statement or do I have to specify that partitions I need to access?
4- I have a huge table with millions of rows and plenty of indexes.But my SQL code runs slow. Assuming that the code is efficient, will partitioning help speed up the code excution?