Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / s
1.Additional 2 byte length indicator is stored along with
the VARCHAR column.
2.It can potentialy affect the amount of logging when the
row with VARCHAR column is updated.
3. The placement of the VARCHAR column in a DB2 table has
performance impact. DB2 has to calculate the offset of the
the column that occurs after the VARCHAR each time the
column is accessed that increases the CPU consumption.
Atleast 5-15 instructions are executed per column.
| Is This Answer Correct ? | 9 Yes | 0 No |
Post New Answer View All Answers
What is ibm db2 client?
What is the use of db2?
What is bind plan?
How to find schema of a table in db2?
Why do we use cursor?
What is the difference between spufi and qmf?
What is the difference between dbm cfg and db cfg file in db2 ?
How do you pull up a query which was previously saved in qmf?
Is db2 relational database?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
How connect db2 database to datastage?
What is the difference between db2 and oracle?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is catalog database in db2?
Define sqlca.
