How to create PLAN_TABLE?



IBM's flagship relational database management system

How to create PLAN_TABLE?

Postby kothai » Wed Dec 23, 2009 2:41 pm

Hi I need to use EXPLAIN command, but couldnt do so as my ID doesnt have PLAN_TABLE for the EXPLAIN command to put it results.
Do any one has syntax to create PLAN_TABLE in a user ID?
kothai
 
Posts: 6
Joined: Fri Aug 28, 2009 1:07 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to create PLAN_TABLE?

Postby dick scherrer » Thu Dec 24, 2009 12:52 am

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

Re: How to create PLAN_TABLE?

Postby Anuj Dhawan » Tue Jan 05, 2010 7:01 pm

Suggest you also get in touch with your DBA.
Anuj
Anuj Dhawan
 
Posts: 273
Joined: Mon Feb 25, 2008 3:53 am
Location: Mumbai, India
Has thanked: 6 times
Been thanked: 4 times


Return to DB2

 


  • Related topics
    Replies
    Views
    Last post