Commit commands with SELECT

[Kay [DAS] Rozeboom]

We have an application with blocks of code that begin with setting autocommit off, and end
with a commit.  The code in between does only selects, no updating.

1)      Am I correct in thinking that the autocommit and commit statements don't really
accomplish anything useful?

2)      If the autocommit and commit statements are unneeded, do they add enough
additional overhead that I should be concerned about them?

Kay Rozeboom
Information Technology Enterprise
Iowa Department of Administrative Services
Telephone: [phone]   Fax: [phone]
Email:  Kay.Rozeboom@stripped