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(dot)klaver(at)aklaver(dot)com