Tuesday, December 6, 2011

DB2 : Getting all the plans for a table

We can get all the plan names associated to a table with this Query.

SELECT DNAME FROM SYSIBM.SYSPLANDEP
WHERE BNAME = '< Your Table Name >' ; 

No comments:

Post a Comment

Note: Only a member of this blog may post a comment.