Re: tuning advisor for an insert statement

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

On Mon, Oct 21, 2019 at 7:47 PM Jeffrey Beckstrom <jbeckstrom_at_gcrta.org> 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

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