Tag Info

New answers tagged


Performance is a very fluid concept. It can vary according, for example, to the number of rows in your tables (use of indexes or not). It can depend on whether you use InnoDB or MyISAM. It can depend on what else is occurring on the system at the same time. It can depend on your hardware. And it can certainly depend on your RDBMS. You ...


To answer your question; WHY? You probably already know this by now since the post is 2 years old. But I'll respond just for the record. The reason #1 requires a commit and #2 doesn't is because the default database setting in Oracle is to commit a transaction when a session ends. If you are in sqlplus and run your code manually, it will not commit the ...

Top 50 recent answers are included