What fields are actually indexed by EnVision to decrease the time it takes to generate reports? Does anyone have a link to the document or know it off the top of their head?
Try running the folowing command to see if this gives a list of the indexed fields in particular table or all tables depending upon how you use it.
lsmaint –varsWithFilter [“Table Name”]
Hope this helps.
Retrieving data ...