Re: Long execution time despite LIMIT 3
Hi Rick,
thanks. Everything you say sounds valid. To your points:
- Yes, about 5880 was the number in that case.
- Your pattern
( SELECT ... ORDER BY ... LIMIT 3 )
UNION
( SELECT ... ORDER BY ... LIMIT 3 )
ORDER BY ... LIMIT 3
is the one I'm working on right now.
- "sufficiently scattered", "cache were cold", "..same query again, it would run much faster" --> everything correct.
I'll try to benchmark the above pattern now.
Regards,
Ben
Subject
Views
Written By
Posted
2537
June 19, 2011 12:47PM
897
June 19, 2011 12:54PM
1042
June 20, 2011 06:33PM
1054
June 20, 2011 11:44PM
992
June 21, 2011 02:06AM
1065
June 21, 2011 07:23AM
Re: Long execution time despite LIMIT 3
855
June 21, 2011 07:28AM
999
June 21, 2011 10:33AM
1052
June 21, 2011 10:08PM
1418
June 22, 2011 12:33AM
980
June 22, 2011 07:26PM
876
June 22, 2011 11:45PM
984
June 23, 2011 08:53AM
998
June 24, 2011 02:51AM
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.