Answer Posted / saeed
clustering index attempts to maintain a particular order of
data, it try to keep newly inserted rows clustered
according to an index and avoid page splits.
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What is db2 purescale?
Explain what are the various isolation levels possible?
How will you return the number of records in table?
How is deadlock resolved?
Is schema the same as database?
Is ibm db2 open source?
What is buffer pool in the db2 database?
Mention the way of highlighting as well as putting a cursor to use in a cobol program.
How to create backup table in db2?
How do I copy a table in db2?
What is the use of value function?
What is reorg and runstats in db2?
What is coalesce in db2?
How do I optimize a query in db2?