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 the reason behind not using select * in embedded sql programs?
What are the bind parameters ibm db2?
How do I change the column size in db2?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
What are the contents of dclgen?
What is blu acceleration in db2?
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
Is ibm db2 free?
What is consistency token in db2?
What is db2 command?
What are the various isolation levels possible?
What is syscat in db2?
How can deadlocks be resolved?
What is the difference between db2 and oracle?
What is a dbrm in db2?
