How To: Decrease drawing time for large shapefiles and/or SDE layers
ArcView draws each feature in a shapefile or SDE layer as it cycles through the data retrieving the shape features associated with each queried record. The more records ArcView has to cycle through, the longer the access and drawing times.
Esri has developed a method deemed Turbo Layers for SDE administrators to increase draw time for SDE layers.
It is possible to download a script that implements this method from the ArcScripts Web site. See Related Information to download the script.
When using the script, the active theme in the active view should be either an FTheme or a DBTheme.