On Jul 29, 2019, at 12:25 , Adrian Klaver <adrian.kla...@aklaver.com> wrote: > > 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.
Isn’t that the entirety of what the query plan is based on? I was hoping I could then run Explain as if I had the data.