Hello,
We are having performance issues with some reports using conditions on date fields in the Record Selection Formula. Our application does not use the time portion of the date fields very often. When Crystal Reports builds the SQL statement to Oracle it uses a range condition to include all the possible time values. This practice makes a big difference compared to a direct condition
Example: SELECT "TABLE_A"."ID"
FROM "TABLE_A"
WHERE ("TABLE_A"."DT">= TO_DATE('2011-03-31 00:00:00','YYYY-MM-DD HH24:MI:SS') AND
"TABLE_A"."DT"< TO_DATE('2011-04-01 00:00:00','YYYY-MM-DD HH24:MI:SS'))
Is there a way to tell Crystal not to perform range validation on dates?
We would like to have a SQL Statment that looks like:
SELECT "TABLE_A"."ID"
FROM "TABLE_A"
WHERE ("TABLE_A"."DT" = TO_DATE('2011-03-31'))
We are on Oracle 11 with Crystal Report for VS2010 Sp1.
Thank you.
Charles