x followed by a unique scan of the D
index. Adding nonsense criteria such as "... and D.UID > 0" doesn't
make things better.
The D table is very wide, so a lot of I/O is wasted by doing a full
table scan.
Thanks!
-- Sincerely, Fred
Frederik Lindberg, CTO, CheetahMail
--
Pleas
s very informative, and as always on this list, I learned a lot
more than I thought asking the question ;-)
-- Sincerely, Fred
Frederik Lindberg, CTO, CheetahMail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Frederik Lindberg
INET: [EMAIL PROTECTED]
Fat Cit
I'm using transactions, with a delete followed by an insert.
If the delete affects 0 rows, there is nothing to do.
Do I need to rollback the transaction to abandon it, or is everything
the way it should after a delete that affected 0 rows?
Thanks!
-- Sincerely, Fred
Frederik Lindberg