Re: How to avoid waiting for locks during delete

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Fri, 08 Aug 2003 20:05:40 +0200
Message-ID: <tgp7jvs7c5ipmld1daffoto2aem9fmagng@4ax.com>

On Fri, 8 Aug 2003 17:49:23 +0200, "André Hartmann" <andrehartmann_at_hotmail.com> wrote:

>
> * If you suggest to lock everything explicitely, that means that when
>issue my delete command i actually have to know all the cascading foreign
>key relations that need to be traced. but i dont (want) to know that. my
>data model will develop and get more enhanced in the future... each time i
>introduce a new foreign key constraint to a base table that is to delete
>cascadingly, i would have to adjust the code around my delete-command to
>make additional locks... thats also unacceptable because its a source of
>errors and iconsistencies.

I don't know what you are talking about. In a properly designed datamodel that doesn't happen. PERIOD.
If you think otherwise, you have to come up with evidence, and likely you will show a MESS

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Aug 08 2003 - 13:05:40 CDT