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 syscat in db2?
What does db2 blu stand for?
What is the use of reorg in db2?
Explain about rct.
What does reorg do in db2?
Define db2 and its databases?
How can you find out the # of rows updated after an update statement?
Explain about open switch business continuity software?
What is the difference between using bind () and rebind () methods of naming class?
Mention the definition of cobol in varchar field.
What is catalog database in db2?
What is lock escalation in db2?
How can record locking be achieved in those DB2 versions which do not support it?
Name the various locking levels available?
What is cursor with hold option in db2?
