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 the maximum size of a char data type in db2?
What is the result of open cursor statement?
Is db2 a database?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What is a db2 cursor?
Which components manage deadlocks in db2?
Explain about rct.
How will you return the number of records in table?
When reorg is used?
If I have a view which is a join of two or more tables, can this view be updateable?
What is meant by explain?
Is schema the same as database?
What is dclgen in db2?
What is the maximum No of rows per page?
What is the use of value function?
