RE: partitioning
- From: "Ric Van Dyke" <ric.van.dyke@xxxxxxxxxx>
- To: <Brian.Zelli@xxxxxxxxxxxxxxx>, "oracle-l-freelists" <oracle-l@xxxxxxxxxxxxx>
- Date: Mon, 15 Nov 2010 08:53:12 -0600
Brian what your describing here sounds more like "archiving" not
"partitioning".
With archiving you would do more or less what you are saying. Some sort
of job running once a month to in effect remove the records from the one
table then put them in to some archive table. But if the use wants
access to both sets of data at any time this would like mean a view on
top of the two tables, which may or may not give you good performance.
Or the application would need to be smart enough to know when to go each
table. You may also want to look into running the job more then just
once a month if the load gets significant.
With partitioning you would likely set up some sort of composite
partition based on the date and the status fields. Oracle will now
automatically put the records into the correct partition, make sure you
enable row movement so that as statuses change the row will be moved to
the right partition. On the application side, so long as the user's
queries use the date and the status fields then oracle will
automatically direct the query to the correct partition for the given
query.
-----------------------
Ric Van Dyke
Hotsos Enterprises
-----------------------
Hotsos Symposium
March 6 - 10, 2011
You have to be there, yea I'm talking to you.
________________________________
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Zelli, Brian
Sent: Monday, November 15, 2010 9:16 AM
To: oracle-l-freelists
Subject: partitioning
Ok folks it's been awhile since I had to partition. So the user wants
the partition done once a month (for now) based on values in a column.
He wants to keep active-type records current and partition off completed
or cancelled records. So basically I would set up a script to run on
the 1st that would look at the values and just partition off correct?
ciao,
Brian
This email message may contain legally privileged and/or confidential
information. If you are not the intended recipient(s), or the employee
or agent responsible for the delivery of this message to the intended
recipient(s), you are hereby notified that any disclosure, copying,
distribution, or use of this email message is prohibited. If you have
received this message in error, please notify the sender immediately by
e-mail and delete this email message from your computer. Thank you.
Other related posts:
