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
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What are catalog tables in db2?
What is ibm db2 database?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is explain plan in db2?
What does db2 mean?
Explain about rct.
What is dbrm? What it contains? When it will be created?
What are the bind parameters ibm db2?
What is isolation level in db2?
What is catalog database in db2?
What is page size in db2?
What are the prerogatives?
What are concurrency issues?
What is db2 bind process?
