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
What is a storage group (stogroup)?
What is the use of commit in db2?
What is check constraint. Explain with example.
How to check table size in db2 sap?
Before you give the explain statement, what are the prerogatives?
How do I add a column to an existing table in db2?
How do you eliminate duplicate values in db2?
What is the physical storage length of the data types date, time, and timestamp?
Can we update view in db2?
How does coalesce work?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
Mention the various locks that are available in db2.
Mention the definition of cobol in varchar field.
How does cobol compile db2 program?
Give a brief description of db2 isolation levels?
