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
How to view db2 table structure?
What is lock escalation in db2?
What is the advantage in De-normalizing tables in DB2?
What is db2 bind process?
How does db2 sample database connect?
What type of database is db2?
What is the use of db2 optimizer?
Why do chiropractors use drop table?
How does cobol compile db2 program?
What is a plan and package in db2?
Can we insert update delete in view?
What does reorg do in db2?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What does sqlcabc has?
What db2 400?
