Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Confusing blocking issue - More Details

Re: Confusing blocking issue - More Details

From: Tim Callaghan <timc_at_channel1.com>
Date: Wed, 29 Jan 2003 09:53:05 -0500
Message-ID: <3lqf3v0a9kcgoatkde64anmq8afi83ci4d@4ax.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US