This content has been marked as final. Show 1 reply
You must first read the below thread end to end.
[HOW TO: Post a SQL statement tuning request - template posting |http://forums.oracle.com/forums/thread.jspa?threadID=863295]
This thread has another thread linked to it which tells you how to trace your performance issue. So give all the details mentioned in that thread here and we can get going from there.
But to start with
use of a function in a column will ignore any index on that column. So do you have any index on transaction_date? If so and if its a useful index for this query then you must consider not to use truncate function.
where trunc(transaction_date) between to_date('01/01/2009','MM/DD/YYYY') and to_date('09/07/2009','MM/DD/YYYY')