Re: Query

is there another table that has a foreign key that references that primary key field?

in any case, doing an explain plan might help you figure this out.

deepesh_garg_at_yahoo.com (Deepesh Garg) wrote in message news:<b21bb3.0212021634.47e72727_at_posting.google.com>...
> It definitely is redundant. The code happen to run queries generated
> by a script, and the script generated it thay way. I removed the set
> part when this problem is found. But still I am not sure why it
> resulted in hanging the query.
> -Deepesh.
>
> Da Man <jeffc_at_sympatico.ca> wrote in message news:<j53guu88t4aac4dodkf62v1rgam25pbbuc_at_4ax.com>...
> > What does look a little strange is your setting the primary_key_field
> > = 100 but your where clause is looking for primary_key_field = 100.
> > That seems redundent to me.
> >
> >
> > On 27 Nov 2002 17:06:11 -0800, deepesh_garg_at_yahoo.com (Deepesh Garg)
> > wrote:
> >
> > >Hi,
> > >I am running a query of this sort (on Oracle 8i) and it seems to hang
> > >most of the time. Can anyone tell me why does it hangs.
> > >
> > >update some_table set some_field = 'some value', primary_key_field =
> > >100 where primary_key_field = 100
> > >
> > >I know its stupid, but I want to know that why this type of query
> > >hangs. If I remove the primari_key_field = 100 from set part of the
> > >query, it runs fine.
> > >
> > >-Deepesh.
Received on Tue Dec 03 2002 - 19:56:08 CET