Re: How to insert data using index unusable/rebuild

JusungYang_at_yahoo.com (Jusung Yang) wrote in message
> You are aware of the fact that SKIP_UNUSABLE_INDEXES does not work for
> unique index, right? If your goal is to avoid hard coding the index
> names in your process script, there is really no need to use
> SKIP_UNUSABLE_INDEXES. If the goal is to avoid index maintainence
> during DML, you are out of luck with UNIQUE indexes. You can use
> SKIP_UNUSABLE_INDEXES to work with the primary key - since primary
> keys do not have to be unique. But not unique indexes.
>
> Your table is not partitioned, yes? You might have better luck with
> partitioned tables. They have more options for you to play around
> with.
>
> - Jusung Yang

Pardon me? Better review database constraints!: "... since primary keys do not have to be unique."! Here's a link: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/clauses3a.htm

Daniel Received on Fri Jul 11 2003 - 19:26:07 CDT