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 copy pending and check pending in db2?
What is role in db2?
Mention the definition of cobol in varchar field.
What is a db2 package?
Which component is responsible for processing sql statements and selecting access paths?
What kind of database is db2?
can all users have the privilage to use the sql statement select * (dml)?
How to get the ddl of a table in db2?
What is the difference between plan and package in db2?
What does runstats do in db2?
How would the varchar column remarks defined?
What is a cursor in programming?
Define check constraint.
Explain about cursor stability?
Which isolation level provides maximum concurrency?
