Originally posted by saurabhvtechno
I run the following Query to check how many number of times full table scan is taking place

To paraphrase TKyte, "all full scans are not evil, all indexes are not good".


My question is should I increase this value for the better performance.How much should I increase?What is the maximum limit for this parameter in Windows NT environment.
My suggestion would be to find which queries are causing FTS and tune them if appropriate. Arbitrarily increasing your mbrc can cause other queries to favor FTS over index hits (which may or may not be good).