EISCAN (User-defined index scan) node

This node scans a user defined index to produce a reduced stream of rows.

Node name: EISCAN

Represents: The scanning uses the multiple start/stop conditions from the user-supplied range producer function. This operation is performed to narrow down the set of qualifying rows before the optimizer accesses the base table (based on predicates).

Performance Suggestion:
  • Over time, database updates can cause an index to become fragmented, resulting in more index pages than necessary. This can be corrected by dropping and re-creating the index, or reorganizing the index.
  • If statistics are not current, update them by using the RUNSTATS command.

Feedback