By default, creating of indexes in CleverPath Reporter is set to true so that tables can be joined based on indexes which results in faster execution. However, on some databases this causes the SQLStatistics call to run on the database which can slow down processing on the database side.
This document will explain how to turn off indexing in CleverPath Reporter so that the SQLStatistics call will not run.
End of Life March 2012
By setting INDEXES to NO we will be turning off creating indexes for the tables and hence no SQLStatistics call will be generated.