How Plan is created while executing the query using SPUFI?
Answers were Sorted based on User's Feedback
Answer / guest
Plan is already created during the installation of the DB2I
tools.
Is This Answer Correct ? | 1 Yes | 1 No |
Answer / arun chinnadurai
A package/plan is created is created for DB2I tools and the
authorization to execute that plan is given to Public.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
wht is d/f between union and joins ?
how can you access index
What is an inner join, and an outer join ?
Is db2 a database?
Which isolation level provides maximum concurrency?
What is isolation level?
How to resolve -407 sql code in DB2?
why db2 is called as universal database?what is the storage capacity of db2v9 n what are the advantages of db2
Explain an outer join?
How can you do the explain of a dynamic sql statement?
What does an outer join do?
Can we use group-by clause in sub-query? If 'yes' means,Will it be executed successfully or else If 'no' means why should we not using that method? Give me your suggestion please....