Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums  SQL Server 2000 Forums  SQL Server Development (2000)  SQL View Performance

Author  Topic  mbaldwin Starting Member 1 Post Posted - 2008-11-21 : 07:38:31 We currently have our ArcGIS SDE on SQL Server 2005 and a parcel database (Govern) on SQL Server 2000. If we try and create a view in 2000 and join the results with the ArcGIS SDE feature class the performance is awful. We then tried to create an SDE View in SQL 2005 based on the parcels pulling the information from SQL 2000 (Linked the servers). The performance increased a little but still is taking a couple minutes to load the data. Does anyone have any suggestions of ways to increase the performance of the data. We have already indexed the appropriate fields. I submitted this question to and ESRI forum and this is what I got in response: Cross-instance views will usually perform poorly -- the RDBMS cannot cache the foreign data and rarely can optimize anything. There may be RDBMS-specific tuning to make this less awful, but that is well outside the scope of an ESRI forum.