When will you chose to run RUNSTATS?
Answer / deepak dada
is the utility which contains the statical info of the
table supply it to optimiser ane fron where it is used for
accessing the data base
| Is This Answer Correct ? | 4 Yes | 4 No |
What is a data page?
What is correlation names?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What are the 2 sqlcodes that are returned?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its
What are leaf pages?
What is nvl in db2?
Mention the location where the output received from explain statement is stored.
Is it possible to precompile if db2 goes down?
How does DB2 store NULL physically?
How do you retrieve the data from a nullable column?
pls explain the precompilation process of cobol-db2 pgm