Re: Deadly sins againts database performance/scalability

(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