•Lots of logicals means lots of
decisions
•Decisions take time
•Indexes typically evaluated in
creation descending order
•Tables with a large number of
indexes can cause optimizer to time out, this can
cause the AS/400 to not see the most appropriate access path