Sometime using explain plan doesn't clearly give a answer to which way to write a query. This template allows a query to be run several times to give a idea of which way is faster.
BEGIN
FOR a IN 1..1000 LOOP
FOR b IN
(
... paste query here ...
)
LOOP
NULL;
END LOOP;
END LOOP;
END;
/
Done.
No comments:
Post a Comment