EXPLAIN REPORT



IBM's flagship relational database management system

EXPLAIN REPORT

Postby Pyari » Mon May 03, 2010 2:54 pm

After writing the SQL query , here we used to prepare explain reports for those in order to check the optimisation of that query. But our DBAs will review those reports and suggest whether it is optimised or not . My doubt is by seeing which fields in explain report we can say that the query is optimised?
Pyari
 
Posts: 1
Joined: Wed Apr 21, 2010 3:22 pm
Has thanked: 0 time
Been thanked: 0 time

Re: EXPLAIN REPORT

Postby dick scherrer » Mon May 03, 2010 11:54 pm

Hello and welcome to the forum,

Suggest you talk with your DBAs and find out what they consider important. . . Opinions vary and the local DBAs should have the best knowledge what is good and not good on your system. . .
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6268
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 93 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post