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 is null indicator in db2?
What are the two types of logging in the db2 database? Explain them.
What os does db2 run on?
What is the syntax for seeing the columns and data types of a table in the db2 database?
What is syscat in db2?
How can you do the explain of a dynamic sql statement?
For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.
What are the contents of a dclmgen?
How to connect to db2 database from windows command line?
How do I delete a table in database?
Who uses db2?
What are the different types of base tables?
What is the advantage in De-normalizing tables in DB2?
What is db2 stogroup?
What is the use of reorg in db2?