What are the disadvantages of using VARCHAR?
- 3 Answers
- 14048 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / vinod babu
Varchar data types have to handle carefully. otherwise high
chances to get -311 error during the process.
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / s
When updating VARCHAR columns, the row may not fit on the
page anymore and a pointer to the new row is left in the
orginal space. Over time, there will be more relocated rows
that degrades performance.
| Is This Answer Correct ? | 6 Yes | 6 No |
What is the error code -803 ?
What does this mean ? GRANT BIND,EXECUTE ON PLAN MK2 TO PUBLIC;
What db2 400?
If there is no row in Emp table with Ename as Raghava and you run the below queries in SPUFI. 1.select Ename from EMP wher Ename = 'raghava' 2.Select count(*) from EMP where Ename = 'raghava' What is SQLCODE shown up in SPUFI
What is a clustering index ?
What is db2 catalog database?
What is a Database Request Module(DBRM)?
What is EXPLAIN?
What is lock escalation in db2?
Is db2 a programming language?
Why do we need reorg in db2?
what's the equivalent Cobol Data type for Decimal(x,y) in DB2? what does the current SQLID register contain?
3 Answers Cap Gemini, Tech Mahindra,
COBOL 
