Re: SELECT executing too long
SELECT r.id FROM .records r WHERE r.filedate >=1674615600.0 AND r.filedate <=1677294000.0 ORDER BY r.filename ASC
executed about 6 sec.
SELECT r.id FROM records r WHERE r.filedate >=1674615600.0 AND r.filedate <=1677294000.0 ORDER BY r.filename ASC LIMIT 20
executed more then 30 sec
Subject
Written By
Posted
February 24, 2023 06:33AM
Re: SELECT executing too long
February 24, 2023 06:36AM
February 27, 2023 08:00AM
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.