Re: Reproducing query plans in empty database: can I just copy stats and settings?

[Guyren Howe <guyren@xxxxxxxxx>]

On Jul 29, 2019, at 12:25 , Adrian Klaver <adrian.klaver@xxxxxxxxxxx> 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.