Re: Choose a partition key LIKELY TO BE UPDATED

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Wed, 15 Mar 2006 14:51:47 GMT
Message-ID: <Xns978745ADB1917ianalvistahotmailcom@70.169.32.36>

"Spendius" <spendius_at_muchomail.com> wrote in news:1142420410.569170.317500 @z34g2000cwc.googlegroups.com:

> 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
>
>

"GOOD" is relative.
It is not necessarily a bad idea.

FWIW- Partitioning is an extra cost option on EE. Are you licensed for partitioning? Received on Wed Mar 15 2006 - 08:51:47 CST