Its always rewarding to talk about lesser known performance tuning scenarios, which are not all that well appreciated in the DBA or developer world. Ask anyone as to what performance tuning has one worked upon and quite likely, you may hear - Ah well, I made sure the stats gathered were the latest, the right index was being used or I used a hint to use the right index. Typical Answer.
How often do we look at other aspects like the frequencey of commits?
Neither is it good to do commits less frequently, nor is it good to over-commit. Moderation is the key for a happy medium and at times, it can have bearings on performance problems as well.
Read the complete discussion here...
