Hi All,<br /><br />I have been searching for, Preparing report from a huge table.<br /><br />Queries am executing now
are,<br/>SELECT count(*) from HUGE_TBL where cond1, cond2;<br />SELECT count(*) from HUGE_TBL where cond1, cond3;<br />
---like this i have different conditions(10-15 different things ) and different amount of conditions ( 2 - 5 condition
).<br/><br />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 ?<br /><br />Such executing the query only once,
andgetting all different outputs required ? or fetching result from some cache ?<br />Or i dont have any other way
?!<br/>