On 9/4/2013 10:13 PM, M Tarkeshwar Rao wrote:
Can you please suggest me some links where I can learn:
1. Transaction Isolation in Database
the documentation
2. Query procession and possible optimizations.
the source code. if there were any easy optimizations, I'm sure they've already been taken.
3. How to improve query and its performance.
see #2 above.
4. MVCC in detail.
see answer to #1, and the source code if you want more detail.
--
john r pierce 37N 122W
somewhere on the middle of the left coast