Does START TRANSACTION cause locks
Posted by:
Joey JS
Date: February 14, 2015 02:34PM
Is there any reason NOT to use the below; e.g. not using any C/U/D statements?
START TRANSACTION;
SET autocommit=0;
SELECT * FROM my_table;
COMMIT;
i.e. Does this lock/slow the query - I couldn't find anything conclusive.
I appreciate this question might even seem pointless but it'll likely lead me on to more research/questions.
Thanks
Joey
Subject
Written By
Posted
Does START TRANSACTION cause locks
February 14, 2015 02:34PM
February 18, 2015 04:01PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.