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
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What do you mean by storage group (stogroup)?
How do I copy a table in db2?
Which component is responsible for db2 startup and shutdown?
What is a db2 collection?
Mention data types used in db2 ?
What is the difference between nvl and coalesce?
What is the physical storage length of time data type?
What is buffer pool in the db2 database?
What is with ur in db2?
What is the difference between spufi and qmf?
What is innodb buffer pool?
What is universal database?
What is bind package and plan in db2?
Can you tell me how can you find out the # of rows updated after an update statement?
