views vs commands

[atthevilla]

Oracle 10g, Crystal 10.
I designed 2 reports, one using a view and another using a command. The command is much slower in reading records (10 minutes vs 4 minutes) even though it has the same syntax as the view. One advantage of a command is the ability to allow parameter input so I want to use this occasionally. Is there any setting to help a command run faster? Why this difference in performance?

 

[hilfy]

In the report with the command, are you using any selection or sort criteria that aren't being processed in the command itself? If so, that could account for the difference because all of the data from the command will be brought into Crystal which will then do the filtering and sorting that are more efficiently done in the database. Since the database sees a view as if it were a table, the database then handles the sorting and filtering instead of Crystal.

-Dell

A computer only does what you actually told it to do - not what you thought you told it to do.