where dates > ‘25-Feb-12’
and dates < ‘05-Mar-12’
group by dates;
If i run the below query for 1 day it takes 1 second. If I run it for 10 days it takes 30 seconds. So it would be more efficient for me to run the query for 1 day ten times and combine the results. Is this possible through the use of a loop?
The table has three fields: TRANSACTIONID, DATES, PAYMENT
(I have read-only access to the database.)