Hi All,
I have been searching for, Preparing report from a huge table.
Queries am executing now are,
SELECT count(*) from HUGE_TBL where cond1, cond2;
SELECT count(*) from HUGE_TBL where cond1, cond3;
--- like this i have different conditions(10-15 different things ) and
different amount of conditions ( 2 - 5 condition ).
As that is a very huge table, it took time to execute each query ( 2 min ).
And finally it takes 15 times that ( 30 min ). Is there anyway to do the
above report efficiently ?
Such executing the query only once, and getting all different outputs
required ? or fetching result from some cache ?
Or i dont have any other way ?!