Plan has the optimized access path in it. But is that
optimized access path is attained or known
Answer / prajakta
It is attained based on results from RUNSTATS utiliry. The Query Optimizer derives it.
Is This Answer Correct ? | 1 Yes | 0 No |
What are union and union all?
How to resolve -504 sql code in DB2?
What language is db2 written in?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
What is with ur in db2?
Could you please let me no the query for below I have table name xyx under this there is column name called employee name which starts from 100th column ends 120th column,now i want to replace only column from 101 to 104 which contains ABCS to replace with PQRS for all records which comes beetween 101 to 104 ..how to write query for this..
what is a collection?
What is cursor stability?
How does DB2 use multiple table indexes?
What is explain plan in db2?
What's the maximum number of volumes that can be added to a STOGROUP?
What types of tables are there in the db2 database?