We are using Oracle; I didn't mention that. Here's the script of the spatial view:CREATE OR REPLACE FORCE VIEW VW_SDE_DEVSTAT_TEST
(
OBJECTID,
STAND_KEY,
DEV_ID,
DEV_DATE,
DEV_STAT_DESCR,
SHAPE
)
AS
SELECT dt.objectid,
dt.stand_key,
dt.dev_id,
dt.dev_date,
dt.dev_stat_descr,
b.SHAPE
FROM FIM.VW_CURRENT_DEVSTAT DT,
FIM.FIMXXPY3 b,
(SELECT SDE_DELETES_ROW_ID, SDE_STATE_ID
FROM FIM.D82
WHERE SDE_STATE_ID = 0
AND FIM.version_util.in_current_lineage (DELETED_AT) > 0) d
WHERE b.OBJECTID = d.SDE_DELETES_ROW_ID(+)
AND d.SDE_STATE_ID IS NULL
AND FIM.version_util.get_lineage_list > 0
AND b.STAND_KEY = DT.STAND_KEY
UNION ALL
SELECT dt.objectid,
dt.stand_key,
dt.dev_id,
dt.dev_date,
dt.dev_stat_descr,
a.SHAPE
FROM FIM.VW_CURRENT_DEVSTAT DT,
FIM.A82 a,
(SELECT SDE_DELETES_ROW_ID, SDE_STATE_ID
FROM FIM.D82
WHERE FIM.version_util.in_current_lineage (DELETED_AT) > 0) d
WHERE a.OBJECTID = d.SDE_DELETES_ROW_ID(+)
AND a.SDE_STATE_ID = d.SDE_STATE_ID(+)
AND FIM.version_util.in_current_lineage (a.SDE_STATE_ID) > 0
AND d.SDE_STATE_ID IS NULL
AND a.stand_key = dt.stand_key;
vw_current_devstat is a view that contains 13941 records that results from a query from the versioned view of the main featureclass which in our case is called fimxxpy3. fimxxpy3 contains 203,099 records. In Oracle using Toad, it takes less than a second to run a simple query on vw_current_devstat.When querying the spatial view, VW_SDE_DEVSTAT_TEST, it takes 1 second to run a simple query. It contains 13943 records.It seems to perform well in Oracle.What steps takes 2 minutes? Opening the table- yesterday it took that long. Today it took about 20 seconds to open the first time and then it seems to open just as fast as any feature class after that. So I'm seeing inconsistencies with its performance.Yesterday, dragging it to the arcmap view, took about 20 seconds to load and draw and today it seems to work well. The performance issues could have been due to accessing the layer when another process was running on the database. I appreciate any insight you might have on this.Sonia