AnsweredAssumed Answered

Will registering a view with an enterprise geodatabase improve performance?

Question asked by ekv5_cdc on May 12, 2020
Latest reply on Aug 11, 2020 by Christian_Wells-esristaff

Hi everyone - Pretty basic question.  Will registering a view that was created outside of ArcGIS improve rendering performance?  I see here a mention that "having spatial information stored in geodatabase system tables improves performance times when adding the table or view to a map."  But, that's all I can find on the subject.  Could someone briefly explain the mechanics behind this?

 

The situation is that we have analysts creating web apps and dashboards directly from SQL Server views.  Our group makes extensive use of SQL views but does not take advantage of registering them.  They have complained about the rendering performance, and I'm wondering if registering the view will make any noticeable difference.

 

I'm just looking for some information that I can take to my colleagues rather than try to have the DBO user run a series of tests.  (I personally don't have the ability to register tables and views on this particular database.)

 

Thanks,

Ryan

Outcomes