If you have DB2 installed, the Optimizer is it. You use it with any of the
supplied tools (Visual Explain, db2expln, db2exfmt).
Note that the analysis will give you the performance of the query on that
system with its statistics and db cfg capacity parameters.
What you will see is how the query is established and its cost expectations
for "that system". You "may" expect the same behavior on your production
system but not necessarily.
Since explains analyse the query against existing tables and objects, they
have to be part of the db.
I don't know of any DB2 tools for free downloads that would give you this
without DB2 itself.
Hope this helps, Pierre.
Pierre Saint-Jacques
SES Consultants Inc.
514-737-4515
----- Original Message -----
From: "Prabhu" <db2udbdba-ezmlmshield-x83457285.[Email address protected]
To: "LazyDBA Discussion" <[Email address protected]
Sent: Tuesday, October 24, 2006 6:02 AM
Subject: DB2 query


> Hi
>
> Is there any DB2 query optimizer tool (free version) available for
> download to check the SQL query performance?
>
>
>
> Regards,
>
> Prabhu KV
>
>
>
> ---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
> To post a dba job: http://jobs.lazydba.com
> To Subscribe : http://www.LazyDBA.com
> To unsubscribe: http://www.lazydba.com/unsubscribe.html
>



DB2 & UDB email list listserv db2-l LazyDBA home page