Optimizer

**oracle_faq** · 03-31-2004, 06:48 PM

How can I change the optimizer_mode with in a PL/SQL procedure?

**slimdave** · 03-31-2004, 07:25 PM

It's untested, but this might work ...

Code:

begin
   execute immediate 'alter session set optimizer_mode=''first_rows''';
end;
/

**oracle_faq** · 03-31-2004, 08:14 PM

slimdave, execute immediate worked nicely.

I was wondering if there was any oracle supplied package to do the same.

**slimdave** · 03-31-2004, 10:08 PM

nope, not as far as i know, but you could always create your own procedure.

Thread: Optimizer