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