Re: Question: Use Trigger to Prevent Deletes with no Where Clause?

From: Noel <tbal_at_go2.pll-l>
Date: Mon, 17 Jan 2005 15:03:38 +0100
Message-ID: <csggqh$od8$1@inews.gazeta.pl>

Użytkownik Thomas Kyte napisał:

> In article <cs8g01$sha$1_at_inews.gazeta.pl>, Noel says...
>

>>Użytkownik Thomas Kyte napisał:

> Oh, now -- you want to talk SPEED? "count(*)" after each delete?
>
> I'll take approach
>
> a) look for where clause (answers the question)
>
> over
>
> b) count rows as they are deleted, when threshold hit -- stop. no one would
> even notice this for 10's of rows, which is the most likely situation.
>
> over
>
> c) count every row in the table every time we delete 0, 1 or more rows.
>

Hello Thomas.

I didn't check previosly, but now i did. As i suspect trigger with count(*) will fire ONCE for statetment, so your interpretation of c is wrong.

-- 
TomekB tbal_at_spam_go2_trap.pl GSM:Plus 607598532
{Peugeot 306 ST, WY - 49245,       GG: 947-891}
{Najlepszy film: telnet towel.blinkenlights.nl}

Received on Mon Jan 17 2005 - 08:03:38 CST