Re: Slow performance when using LIMIT 1000
Posted by:
Rick James
Date: February 27, 2015 01:09AM
See if this runs faster:
( SELECT *
FROM GroupCall
WHERE CallInitiated >= '2015-02-16 20:10:00'
AND CallInitiated < '2015-02-16 20:50:00'
ORDER BY CallInitiated DESC
LIMIT 1000
)
UNION DISTINCT
( SELECT *
FROM GroupCall
WHERE CallBegin >= '2015-02-16 20:10:00'
AND CallBegin < '2015-02-16 20:50:00'
ORDER BY CallInitiated DESC
LIMIT 1000
)
ORDER BY CallInitiated DESC
LIMIT 1000;
Subject
Views
Written By
Posted
1882
February 25, 2015 07:43AM
843
February 26, 2015 04:13AM
Re: Slow performance when using LIMIT 1000
1004
February 27, 2015 01:09AM
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.