Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Confusing blocking issue - More Details
John,
In my scenario I've actually got 2 indexes:
First is my PK index (location).
Second is my Unique index (location_id + last_touch_date).
-Tim
On Wed, 29 Jan 2003 14:48:49 -0000, "Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote:
>
>I forgot to mention - the trigger has
>nothing to do with it. It's all down
>to the index (id, timed) supporting
>the primary key (id).
Received on Wed Jan 29 2003 - 08:53:05 CST