Interested to Buy Any Domain ? << Click Here >> for more details...
What are the disadvantages of using VARCHAR?
- 3 Answers
- 15413 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 |
in GDG: is it poosible to copy records from a file which utilizes some 100 cylinders to a gdg whose model is defined as trk(1,0) and also it possible to copy 100 bytes file to 80 bytes file?
when i am trying to update a table having 1000 rows. the program abends.how we will come to know the last successful updated row was. we are not using any commit operations
What is dbrm in db2 database?
How and when does the db2 enforces the unique key?
what is the difference between where clause and having clause
When is the authorization check on DB2 objects done - at BIND time or run time?
can we view the access paths created by dbrm ? how ? thx
What are delete-connected tables?
What is the maximum length of a column name in DB2? 18 or 30 or anything other than these?
how can you save the query in QMF?IS IT POSSIBLE OR NOT.IF POSSIBLW HOW?
What r the comman abends in db2, jcl and cobol???????
what's the best lock size that you could use when you create a tablespace?
COBOL 
