On 7/29/19 12:07 PM, Guyren Howe wrote:
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?
So what defines restricted access?
If you can't see/use the data in the production database in your test
database I'm not sure how copying the statistics/cost settings is going
to help.
--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx
