Create Spatial Views

Rather than using Join Layers to create the Calls and Load Points layers, you can use Spatial Views. All other Responder layers are created using XY Event Layers or Query Layers. With this method, Responder users may see an increased performance.

First, have your Database Administrator create Spatial Views in the database.
Oracle

Below is a sample Oracle script for the Calls view, followed by a sample script for the Load Points view.

Calls:

sdetable -o create_view -T CALLS_SPVIEW -t ARCFM.SERVICEPOINT,RESPONDER.RX_CALLS –c ARCFM.SERVICEPOINT.OBJECTID,RESPONDER.RX_CALLS.ID,RESPONDER.RX_CALLS.DEVICE_OID,RESPONDER.RX_CALLS.DEVICE_FCID, RESPONDER.RX_CALLS.INCIDENT_ID,RESPONDER.RX_CALLS.CUSTOMER_ACCOUNT,RESPONDER.RX_CALLS.TROUBLE_AT_ACCOUNT -w "ARCFM.SERVICEPOINT.OBJECTID=RESPONDER.RX_CALLS.DEVICE_OID" -i sde:oracle10g -u username -p password@server -s server

Load Points:
```
sdetable -o create_view -T LOADPOINTS_SPVIEW -t ARCFM.SERVICEPOINT,RESPONDER.RX_LOADPOINTS 
-c ARCFM.SERVICEPOINT.OBJECTID,RESPONDER.RX_LOADPOINTS.ID,RESPONDER.RX_LOADPOINTS.DEVICE_OID,RESPONDER.RX_LOADPOINTS.DEVICE_FCID,
RESPONDER.RX_LOADPOINTS.INCIDENT_ID -w "ARCFM.SERVICEPOINT.OBJECTID=RESPONDER.RX_LOADPOINTS.DEVICE_OID" -i sde:oracle10g 
-u username -p password@server -s server
```
MSSQL

For MSSQL, create a view using SQL Server Management Studio. Below is a sample SQL that the view can run for the Loadpoints spatial view:
```
     SELECT gisadmin.SERVICEPOINT.OBJECTID, gisadmin.SERVICEPOINT.Shape, Responder.RESPONDER.RX_LOADPOINTS.ID, Responder.RESPONDER.RX_LOADPOINTS.DEVICE_OID,
     Responder.RESPONDER.RX_LOADPOINTS.DEVICE_FCID, Responder.RESPONDER.RX_LOADPOINTS.INCIDENT_ID FROM Responder.RESPONDER.RX_LOADPOINTS INNER JOIN
     gisadmin.SERVICEPOINT ON Responder.RESPONDER.RX_LOADPOINTS.DEVICE_OID = gisadmin.SERVICEPOINT.OBJECTID
```
The shape field is also included to make it a spatial view.

Once your Database Administrator has created these scripts in the database, you can add them to your Responder_cached group in ArcMap.
In ArcMap, right-click Responder_cached on the Display tab and select Add Data.
Browse to and select the views for Calls (e.g., CALLS_SPVIEW) and Load Points (e.g., LOADPOINTS_SPVIEW).
Click OK.

For an additional performance improvement, do not display these layers at large scales.

Oracle

MSSQL