Interested to Buy Any Domain ? << Click Here >> for more details...
Plan has the optimized access path in it. But is that
optimized access path is attained or known
- 1 Answers
- 4450 Views
- IBM, I also Faced
- E-Mail Answers
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 happens to the PLAN if index used by it is dropped?
select * from orders where odate between '2010-01-01'and '2010-03-31' How do u fetch this into cursor?
What is db2 optimizer?
If a table has a column "dept" (declared to have nulls) and there are 10 rows in the table of which 3 have a null value in the dept column, what will select count(*) and select count(distinct dept) return?
What is the significance of the CURSOR WITH HOLD clause in a cursor declaration?
wht are the restrictions for union ?
Under what circumstances will DB2 allow an SQL statement to update more than one primary key value at a time?
Can we able to find all the Table names under a Particular Plan?
List out the data types available.
What is host variable in db2 cobol?
What is the difference between a package and a plan?
6 Answers Infosys, L&T, Mphasis,
What is the purpose of the QUIESE Utility?
COBOL 
