QUERY TUNING FUNDAS

duam lee

QUERY TUNING FUNDAS
Good Day Dear Listers ,

After a long I am coming with a silly question. But bit confused so seeking
help of SQL gurus.

I had a sql query and it was with three blocks with one planno. Now when i
tune it goes for one sql block and two planno. As i had not tested it in
production, i am having doubt. Now my question is the query with three
queryblocks with one planno would be costlier than query executing within
one queryblock but two planno.

Thanking you all in advance

Duam

---------------------------------------------------------------------------------
Welcome to the IDUG DB2-L list. To unsubscribe, go to the archives and home page at http://www.idugdb2-l.org/archives/db2-l.html. From that page select "Join or Leave the list". The IDUG DB2-L FAQ is at http://www.idugdb2-l.org. The IDUG List Admins can be reached at [login to unmask email] Find out the latest on IDUG conferences at http://conferences.idug.org/index.cfm