Kbase P23287: How to analyze your Report Builder Query
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
25/11/2003 |
|
Status: Unverified
GOAL:
How to analyze your Report Builder Query
FIX:
Use the start-up parameter -rbzsqldump and create a directory called c:\foo.
This will create a log file c:\foo\sql.log which contains all of the ESQL generated by Report Builder for a report. The directory c:\foo must exist before Report Builder is run with this parameter.
This report will show you all of the SQL queries being made which you can in turn use to optimize your report.