Monthly Archives: July 2012

Why parallelism is not desired in OLTP database enviornment.

 a) Many time out of date statistics or missing indexes can lead to parallelism in OLTP environment. Contrarily to OALP in most OLTP environment a transaction touches few numbers of rows so large table sca n is not desired which … Continue reading

Posted in SQL Tricks and Tips | Leave a comment