I work with Protected Health Information so have restricted access to an important database. I would like to look into index and query changes for that database. It occurs to me that if I was able to reproduce the statistics and cost settings for the database, then Explain would produce identical results to the production database. Can do this? Any other advice? |