Answer Posted / 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 |
Post New Answer View All Answers
What are host variables in db2?
How do you stop a db2 database in linux?
what are bind concepts in db2 cobol?
What is alias in db2?
How can the firstname and the lastname from the emp table be concatenated to generate complete names?
What is the clustering index in the db2 database?
How do I delete a table in database?
What is db2? Explain.
What is db2 connect?
How does db2 sample database connect?
Explain what are the various isolation levels possible?
How will you return the number of records in table?
What does db2 stand for?
What is scrollable cursor in db2?
Explain package in db2 and its advantages?