• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 261
  • Last Modified:

partition table

I am looking to speed up full table scans by partitioning a table. Do a first create the partition table, then bring the data in and then drop the old table?
0
msimons4
Asked:
msimons4
1 Solution
 
slightwv (䄆 Netminder) Commented:
>>I am looking to speed up full table scans by partitioning a table.

I assume you've already done your homework and have verified this will speed up the system as a whole?



There are a lot of links out there on how to partition an existing table.  The exact method you use should be based on what makes sense in your specific system.


Partitioning an Existing Table using DBMS_REDEFINITION
http://www.oracle-base.com/articles/misc/PartitioningAnExistingTable.php

Partitioning an Existing Table using EXCHANGE PARTITION
http://www.oracle-base.com/articles/misc/PartitioningAnExistingTableUsingExchangePartition.php

There are more if you Google around a little.
0

Featured Post

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now