Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal 9.0 RAS performing full table scans on each report run

Status
Not open for further replies.

jmeehan

ISP
Jun 18, 2003
6
US
I am trying to use Crystal 9.0 RAS against a DB2 database and each time I run a report, a full table scan is done before the report will run. Anyone know if there is a setting I'm missing here? Reports that should be running under 30 seconds are taking 12 - 15 minutes to run.
 
Check the linking strategy. A full outer join can cause this. Also double check the record selection criteria. It may be searching for some value that it is not locating.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top