
Crystal Report running slow off a view
I have a report that is designed to pull records from a view. The report
needs to order the data so the SQL query that is created contains an order
by. The view takes about 16s to populate its information but the report is
taking over three minutes to run. The view is only returning 2200 rows.
The sql query that crystal is creating looks like this:
SELECT
Call_Table_Alias."Div_Name", Call_Table_Alias."Dep_Name",
Call_Table_Alias."Extension", Call_Table_Alias."Extension_Name",
Call_Table_Alias."Duration", Call_Table_Alias."Cost",
Call_Table_Alias."Calls"
FROM
"CallTable"."dbo"."T_2003_06_11_REP_007662656_June_Summary"
Call_Table_Alias
ORDER BY
Call_Table_Alias."Div_Name" ASC,
Call_Table_Alias."Dep_Name" ASC,
Call_Table_Alias."Extension" ASC
Any help would be greatly appreciated. Thanks.