How Plan is created while executing the query using SPUFI?
Answer Posted / mangesh
No Plan is get created while executing the query using
SPUFI. SPUFI , QMF are only tools to check the correctness
of your query , i.e where ur query is correct or u have
coded anythig wrong .
| Is This Answer Correct ? | 6 Yes | 7 No |
Post New Answer View All Answers
Why do chiropractors use drop table?
Explain in brief how does db2 determine what lock-size to use?
Where do you specify them?
What is declare cursor?
What do you mean by storage group (stogroup)?
Mention the various locks that are available in db2.
What is cursor stability in db2?
Following a db2 update statement, what is the quickest way to compute the total number of updated rows?
What is ibm db2 database?
Define data page.
What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?
How would you find out the total number of rows in a db2 table?
How do I add a column to an existing table in db2?
What is the cobol picture clause of the db2 data types date, time, timestamp?
What is release/acquire in bind?