Re: tuning advisor for an insert statement

Hi Jeffrey,

Yes, as far as I remember it executes DML, but then it executes rollback.

Niall,

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

AFAIK, CBO automatically sets ALL_ROWS mode for INSERT..SELECT

On Mon, Oct 21, 2019 at 10:59 PM <niall.litchfield_at_gmail.com> wrote:

> 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
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE Associate
http://orasql.org

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