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
Mention the location where the output received from explain statement is stored.
What is universal database?
What is a trigger in the db2 database?
What is the maximum number of columns in a db2 table?
What db2 400?
What is the latest version of ibm db2?
What are foreign keys in db2?
What is the physical storage length of timestamp data type?
What is cursor stability in db2?
Which component is responsible for processing sql statements and selecting access paths?
What is phantom read in db2?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Cursors can be declared in both working-storage & procedure division, agreed. But is there any difference? If could you please suggest what is the difference
How connect db2 database to datastage?
What are union and union all?