SQL TUNING - Does it make a difference, really?

I have read in a couple differency oracle tuning books that using explicit cursors will save time if used in place of implicit cursors.

Will this save a significant amount of time over the extent of the application?

I know it depends on the size of the app, sql statements, etc. but if someone has a general idea - like it may increase the performance overall by x% that would help.

What do you think?

Thanks in advance.

Oracle DBA/Developer
NGX Canada Inc.
Calgary, AB Received on Fri Jun 14 1996 - 00:00:00 CEST