Re: Advice on this statement please?
Temp tables by themselves may significantly slow down a big query, or may not. It depends on the query, the tables, the load and your configuration.
To find problematically slow queries, enable the slow query log, then for the slowest queries run Explain Analyze on them, use that output to optimise them and add covering indexes ... if you get stuck, post the query and the Explain Analyze result in the "Performance" or "Optimizer & Parser" forum.
Subject
Written By
Posted
Re: Advice on this statement please?
April 05, 2022 09:28AM
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.