Re: table fetch continued row

From: Frederic PAYANT <fpayant_at_club-internet.fr>
Date: 23 Oct 2002 07:09:10 -0700
Message-ID: <b6525ebd.0210230609.56f705fa@posting.google.com>

JusungYang_at_yahoo.com (Jusung Yang) wrote in message news:<130ba93a.0210202224.6f3b4aa6_at_posting.google.com>...
> Well, avoid accessing the table while the global index is being
> rebuilt.

Impossible, application must be up 24/24 7/7

> Is local index a possibility for you?

No, this index has been designed to be unique (and doesn't include partitioning key
> Is this a data warehouse type of environment? The fact that a new partition
> is being added daily to the table seems to suggest that it is. If so, why are
> there insert statement run against the table? Seems a bit unusual.
No, OLTP database. This table is used as an archive one so requests begin by inserting a row inside.

Do you think that dropping index _before_ droping/creating partitions and re-creating index after could be an issue ? The only risk is that a user try to inser a duplicate key during time index is offline, but this is a quite rare event !

Thanks for your help
Have a nice day Received on Wed Oct 23 2002 - 09:09:10 CDT