Interested to Buy Any Domain ? << Click Here >> for more details...
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
How to access db2 tables in mainframe?
What is the maximum No of rows per page?
What is table space in db2?
What is the syntax for seeing the columns and data types of a table in the db2 database?
How and when does the db2 enforces the unique key?
What is difference between rollback and commit?
What is ibm db2 client?
can all users have the privilage to use the sql statement select * (dml)?
What is buffer pool and list some of them?
How do you pull up a query which was previously saved in qmf?
What is the maximum size of a char data type in db2?
What is the difference between cursor stability and repeatable read isolation levels?
What is a dbrm in db2?
What are the different types of base tables?
What is an instance in db2?
