possible in PL/SQL (and any other language). That way, you give the compiler maximum freedom to optimization. -- Create Driver for Test I generate 100,000 rows for my cursor using by CONNECT BY LEVEL ...

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production With the Partitioning and Data Mining options $ sqlplus myuser/mypass @demo_test ...