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 accessing 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 recreating the index, or reorganizing the index.
- If statistics are not current, update them using the runstats
command.