Re: table fetch continued row

Hi Frederic,

Teeny weeny comment embedded.

"Frederic PAYANT" <fpayant_at_club-internet.fr> wrote in message news:b6525ebd.0210230609.56f705fa_at_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

This doesn't necessarily mean it can't be local. You can have a unique non prefixed local index, which might be advantages if maintenance on a global index is an issue.

Cheers

Richard

> > 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 Thu Oct 24 2002 - 08:36:13 CDT