When working with a large layer created from an XY event source, drawing speed and identify results are very slow.
The X and Y coordinate fields are not indexed. This slows down the queries on these fields.
Solution or Workaround
Add indexes to the X and Y fields for the point event table.
- Select the table in ArcCatalog and right-click to open the Table Properties dialog box.
- Click the Index tab.
- Add new indexes to the table for the X and Y fields.