asked
can you please suggest how to optimize this query : select a.col1,a.col2,count(b.col1) as cnt from table1 a,table2 b where b.col2 between a.col1 and a.col2 group by a.col1,a.col2
can you please suggest how to optimize this query : select a.col1,a.col2,count(b.col1) as cnt from table1 a,table2 b where b.col2 between a.col1 and a.col2 group by a.col1,a.col2
Look at your ex.plan and set statists io on to see with table has the most logical reads
your understanding of the requirement must be wrong. Try to understand what result you need to generate.
19 People are following this question.
