Re: tuning advisor for an insert statement

  • From: niall.litchfield@xxxxxxxxx
  • To: "JBECKSTROM@xxxxxxxxx" <jbeckstrom@xxxxxxxxx>
  • Date: Mon, 21 Oct 2019 20:58:26 +0100

if it is an INSERT...SELECT does an ALL_ROWS select help?

On Mon, Oct 21, 2019 at 7:47 PM Jeffrey Beckstrom <jbeckstrom@xxxxxxxxx>
wrote:

I have a poorly performing Insert statement I would like to run the Tuning
Advisor against. If I do so, won't the Tuning Advisor actually execute the
statement thus inserting rows into the table?

Jeffrey Beckstrom
Lead Database Administrator
Information Technology Department
Greater Cleveland Regional Transit Authority
1240 W. 6th Street
Cleveland, Ohio 44113



-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

Other related posts: