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.