Thread: Explain Plan
View Single Post

   
  #6 (permalink)  
Old 04-08-2008, 06:19 PM
Mark A. Parsons
 
Posts: n/a
Default Re: Explain Plan

I haven't looked at the link you posted but, generally speaking, yes you
can implement these commands programmatically.

Obviously (?):

1 - you would want to be able to configure this on-the-fly; there's a
performance hit for generating/sending all that text to the client, so only
use it when trying to track down a performance issue

2 - the client has to be (re)configured/(re)written to handle the results
of these commands

badbrownie@gmail.com wrote:

> By the way is it possible to use 'show plan' programmatically? I
> understand how it can be used from the console but I need to use it
> from within java (and parse its results programmatically too of course)
>

Reply With Quote