Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Choose a partition key LIKELY TO BE UPDATED
Hi,
An analyst-programmer came to me and said they had chosen
to create a partitioned table on a DATE field that is supposed
to be updated (on a more or less regular basis, and not for
all records contained in that table) in such a way that it would
have to displace the rows related to this update: I have but ONE
question: frankly, is this a good idea ??
Thanks.
Spendius
Received on Wed Mar 15 2006 - 05:00:10 CST