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 query_cache_limit?
What is innodb buffer pool?
How to view db2 table structure?
Describe major components of db2?
How to execute stored procedures?
Define db2 and its databases?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What do you mean by between and in? Is between inclusive of specified range values?
What action db2 takes when a program aborts in the middle of a transaction?
What is a Foreign Key?
Mention data types used in db2 ?
What is the role of data manager in the db2 database?
Define data page.
What is a bind in db2?
What is check constraint. Explain with example.
