What else is there in the PLAN apart from the access path?
Answer / s
The Plan contains the executable SQL code(if DBRMs are
directly bound to the plan) with its access path as well as
the consistency token that will be checked against the
contoken in the load module at execution time.
| Is This Answer Correct ? | 3 Yes | 0 No |
what is REORG? what is the use?
Are view updateable?
How do you define a correlated name?
What is a composite index and how does it differ from a multiple index?
What is deadlock?
max number of columns in a db2 table?
How to find the maximum value in a column in the db2 database?
What is buffrpool? Where we use it ?
I HAVE 2 TABLES ONE IS EMP_TABLE AND ANOTHER DEPT_TABLE.EMP_TABLE CONTAINS NAME,DEPTNO,DEPTNAME,LOCATION AND DEPT_TABLE CONTAINS DEPTNO,DOJ(DATE OF JOINING).I WANT TO DISPLAY NAME,DEPTNAME,DOJ AND WHO ARE JOINED BETWEN 01- JAN-2007 TO 01-JAN-2008?
How to insert more than one record using insert?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?