Re: Make optimized LEFT JOIN with GROUP BY
Hm, is this better to use? The SQL_CALC_FOUND_ROWS changes my queery so it is quite slowe (using where, using filesort) :-(
Jerry
Subject
Views
Written By
Posted
13219
May 03, 2006 08:30AM
5569
May 03, 2006 09:11AM
4457
May 03, 2006 09:20AM
4043
May 03, 2006 09:21AM
6232
May 03, 2006 01:19PM
4342
May 03, 2006 02:38PM
2873
May 03, 2006 02:43PM
3903
May 03, 2006 03:35PM
3840
May 03, 2006 12:58PM
2766
May 03, 2006 01:17PM
2639
May 03, 2006 01:23PM
2542
May 03, 2006 04:03PM
2411
May 03, 2006 04:17PM
4591
May 03, 2006 04:29PM
2706
May 03, 2006 05:09PM
2724
May 03, 2006 05:45PM
2832
May 03, 2006 06:41PM
Re: Make optimized LEFT JOIN with GROUP BY
2623
May 04, 2006 06:05AM
4175
May 04, 2006 08:10AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.