Re: Query went from millisec/exe response time to 1-2 seconds per exe

Could something have changed with the skew of the underlining data to cause a different number of rows returned?

> On Nov 13, 2024, at 5:40 PM, Ethan Post <post.ethan_at_gmail.com> wrote:
>
> 
> I can't recall a time when I have ever seen query performance change and it only be CPU time when the query and the plan have not changed. I have a lot of history and it is running with the same plan as it always has. No indexes were touched, the table was not purged or anything. It is a large 100+ GB table. Anyone seen this type of thing and have any ideas as to what might cause this? OCI cloud and only this query so not a CPU changed behind the scenes - in the cloud thing.
>
> <image.png>
>

--
http://www.freelists.org/webpage/oracle-l