Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> advice required on partioning
I have a table with a date field that lends itself to partitioning. However
this is not the field that is used in most queries, so I currently have 2
indexes on other columns in the table.
I want to partition the table mainly to speed up deletes, which are done based on values in date field. This allow me to drop a partition rather do a normal delete.
Does it make sense to
John
-- http://www.freelists.org/webpage/oracle-lReceived on Wed Jan 26 2005 - 09:10:53 CST
![]() |
![]() |