Re: Help on Query with DATE BETWEEN not performant
I just disabled the cache, did a restart ... lowered the number of instances to 2.
and did try your query ... duration shows 12.2sec, fetch is 155sec for 23367 rows returned.
Another thing I did .. is I forced index that has date & ID in it ... explain plan showed 1.2mil rows ... executing this took 2.5sec for duration and fetch was 6.8
where without this force it tool 11.7sec for duration & 10.7 for fetch ...
I just used another customer that I didn't use before.
I tried STRAIGHT_JOIN but no difference either ...
is our database totaly messed up or are we missing something ??
Peter ... your help is so appreciated, thank you for your time trying to solve this mystery
Subject
Views
Written By
Posted
2713
February 02, 2020 06:51PM
1019
February 02, 2020 07:13PM
981
February 02, 2020 10:30PM
961
February 03, 2020 04:16AM
956
February 03, 2020 08:12AM
1655
February 03, 2020 10:45AM
1016
February 03, 2020 11:20AM
927
February 03, 2020 12:02PM
Re: Help on Query with DATE BETWEEN not performant
932
February 03, 2020 12:26PM
945
February 03, 2020 04:19PM
1688
February 03, 2020 06:21PM
968
February 03, 2020 08:38PM
1701
February 04, 2020 01:03PM
1097
February 04, 2020 01:42PM
1792
February 04, 2020 02:48PM
1697
February 04, 2020 05:26PM
1422
February 04, 2020 05:27PM
932
February 06, 2020 04:21PM
1205
February 06, 2020 04:31PM
1687
February 06, 2020 10:57PM
1354
February 09, 2020 08:46AM
941
February 09, 2020 11:48AM
1732
February 09, 2020 05:04PM
858
February 04, 2020 04:12PM
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.