i have a history table . i m fetching each date's record count.The below query is taking a longer time
select trunc(history_date),count(*)
from history_reads
group by history_date
Can anyone tune this query so that it should run faster ??
Results 1 to 4 of 4
Thread: Need to tune the sql query
|