For a SQL Server database having an index is always beneficial and from performance point of view too. But how about the clustered index which is occupying space on the database that is not used by any of the queries in the database. The Query Optimizer thinks that column statistics are useful, there...
I don't believe you would need to reset the cache on a production server, it is not a best practice to perform in this case. Most of the times in development or test environments for the purpose of benchmarking you would need to reset the cache for optimum results. You may know that in this case...
We all know that the cached query plans are good to go to attain the performance and no doubt that inefficient query plan will cause more distress to performance with an increased spike in CPU consumption. At the same occurrence of recompilation of a stored procedure is not a good show either. So how...