Re: Is there any graphical tools , able to construct derby query plans ?
Hmm. I could urge you to buy my book ("Apache Derby: Off to the
Races") or I could just point you to the appropriate section of the
manual... ah heck, query analyis is pretty well-documented in the
"Tuning Derby" manual:
http://db.apache.org/derby/docs/10.1/tuning/ttundepth33391.html and
http://db.apache.org/derby/docs/10.1/tuning/ctundepth13055.html are
good places to start!
Dan
(saw a copy of the book on the shelves in a real live bookstore last
weekend -- that was pretty exciting!)
On 2/23/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote:
> Satheesh Bandaram wrote:
>
> > I am not aware of any existing tool that can display RUNTIMESTATISTICS
> > output in a graphical mode. Derby has capability to spit out query plan
> > information in text, but it could use tools to consume this information
> > and display in graphical way. You have any interest? :-)
>
> Can you tell me how you get the query plans out in text form please?
>
> -
> John English | mailto:[EMAIL PROTECTED]
> Senior Lecturer | http://www.it.bton.ac.uk/staff/je
> School of Computing & MIS | ** NON-PROFIT CD FOR CS STUDENTS **
> University of Brighton|-- see http://burks.bton.ac.uk
> -
>
Re: Is there any graphical tools , able to construct derby query plans ?
Satheesh Bandaram wrote: I am not aware of any existing tool that can display RUNTIMESTATISTICS output in a graphical mode. Derby has capability to spit out query plan information in text, but it could use tools to consume this information and display in graphical way. You have any interest? :-) Can you tell me how you get the query plans out in text form please? - John English | mailto:[EMAIL PROTECTED] Senior Lecturer | http://www.it.bton.ac.uk/staff/je School of Computing & MIS | ** NON-PROFIT CD FOR CS STUDENTS ** University of Brighton|-- see http://burks.bton.ac.uk -
Re: Is there any graphical tools , able to construct derby query plans ?
I am not aware of any existing tool that can display RUNTIMESTATISTICS output in a graphical mode. Derby has capability to spit out query plan information in text, but it could use tools to consume this information and display in graphical way. You have any interest? :-) You could file a NEW FEATURE request in JIRA. Satheesh Legolas Woodland wrote: > Hi > Thanks for reading my post > I searched the web site and did not find any helpful entry , so i post > here. > Is there any tools capable to show Derby query plan in a graphical > mode , something like > What another member posts ? (that was for DB2) > > I should optimize my queries (Im not an expert and i think i could do > it with graphical tools easier) > So im looking for a tools capable to show query plans. > Thanks > > >
