Re: Deadly sins againts database performance/scalability

"Marc Blum" <blumNOSPAM_at_marcblum.de> a écrit dans le message news: k2qcsv0ds3tm0qb0fmssn2oipag7bsaod4_at_4ax.com...
> (1)
> SELECT DISTINCT ...
>
> (2)
> ... WHERE <attribute> IN (SELECT DISTINCT ...)
>
> (3)
> LOOP
> EXECUTE IMMEDIATE some_sql;
> END LOOP;
>
> (4)
> SELECT MAX(id) + 1 AS new_id FROM big_table
>
> (5)
> WHERE TRUNC(date_attr) = TRUNC(date_variable)
>
>
>
> --
> Marc Blum
> mailto:blumNOSPAM_at_marcblum.de
> http://www.marcblum.de

Hello,

Why
(3)
LOOP
   EXECUTE IMMEDIATE some_sql;
END LOOP;
should be avoided ??

OK, it's Dynamical SQL but it could be useful to write scalable batch scripts.
Tell me if i'm wrong.

Cheers,
Alkos Received on Fri Nov 28 2003 - 03:52:25 CST