Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of using VARCHAR?
- 3 Answers
- 15670 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 cobol picture clause of the db2 data types date, time, timestamp?
What is the SQL Communications Area and what are some of its key fields?
can I alter a table (e.g. adding a column) when other user is selecting some columns or updating some columns from the same table?
Suppose if I need to update a column, how you do that using cursor?
In which column of which DB2 catalog would you find the length of the rows for all tables?
How to find the number of rows in a db2 table?
What is buffrpool? Where we use it ?
How do you pull up a query which was previously saved in qmf?
what is differnece between DROP TABLE & DELETE TABLE .
What is db2 optimizer?
How would the varchar column remarks defined?
What is the use of runstats in db2?
COBOL 
