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.

Reply via email to