Answer Posted / vat
Contains information about access paths and the internal
form of the SQL for an application plan. Entries in this
table are made when a plan is bound (BIND PLAN) and deleted
when a plan is freed (FREE PLAN). This table is also loaded
into memory at execution time
| Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
Explain about rct in db2?
What is a bind in db2?
Mention the location where the output received from explain statement is stored.
What is reorg?
What is the default page size of buffer pools?
What happens in bind step in a db2 program?
What is the role of data manager in the db2 database?
What are the full forms of spufi and dclgen and why are they used?
What are union and union all?
What are the prerogatives?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is innodb buffer pool?
What is role in db2?
What are the contents of dclgen?
What does db2 mean?