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 ?!
