What are the disadvantages of using VARCHAR?
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 DECLARE TABLE in DCLGEN necessary? Why it used?
Hi , I am posting some interview ques . what is the use of cursors ? what is the diff between select and cursor ? bith are used for data retrival .. rite?
What is ibm db2 used for?
How to find the number of rows in db2 tables?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
Why db2 is called db2?
Where besides the DB2 catalog is database object information stored by DB2?
select distinct(empid),distinct(dept),name from EMP will the above query work?
What is isolation level?
what is check point and restart Logic ? why do we go for that ??
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
What is DCLGEN ?