Re: Optimizer wonk sought

From: Oxnard Montalvo <oxnard_at_carolina.rr.com>
Date: Thu, 24 Apr 2008 11:14:21 -0400
Message-ID: <9446606.204871209050062046.JavaMail.root@cdptpa-web28-z02>

Oracle must perform a context switch to run the stored procedure in the function. Your goal is to put all that stuff in one SQL statement. Trying hints and such will probably not get you to where you want to be.

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

Received on Thu Apr 24 2008 - 10:14:21 CDT

This message: [ Message body ]
Next message: Jared Still: "Re: IPC vs TCP"
Previous message: Anjo Kolk: "Re: SQL Performance Analyzer like software for 9iR2"
Maybe in reply to: Mary Elizabeth McNeely: "Optimizer wonk sought"
Next in thread: Mark W. Farnham: "RE: Optimizer wonk sought"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message