AnsweredAssumed Answered

query versioned view in Microsoft SQL Server Manager extremely slow

Question asked by SRoberts on May 15, 2013
Latest reply on Jul 5, 2013 by SRoberts
I created a versioned view for a feature class with about 60,000 features and am querying the view with a simple select statement in MSSMS.  The query to select 1 indexed field takes about 5 minutes to complete.  We do a low volume of editing on the database, and have a nightly automated job to do a compress, rebuild indexes, and analyze datasets.  Any ideas on how to improve the performance?

SELECT apn FROM gis.PARCEL_VW

Outcomes