What are the disadvantages of using VARCHAR?
- 3 Answers
- 14083 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 |
Is it Possible to declare or create a cursor for UPDATE of table? If yes tell me how? If no Tell me why?
what is cursor stability?
what are the max. & min. no. of partitions allowed in a partition tablespace?
What is db2 plan table?
What is an instance database?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
Can you use max on a char column?
how many bytes timestamp token occupies?
6 Answers Boss Global, Cap Gemini, TCS,
pls tell me abt the normalization five types....
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
When is the skeleton cursor table created?
What is the maximum number of columns in a db2 table?
COBOL 
