Answer Posted / pradeep
a clustered index is a indexin which both index and data
rows will be arranged in some particular sequence
datarows will be arranged based on the index in leaf pages
| Is This Answer Correct ? | 10 Yes | 3 No |
Post New Answer View All Answers
can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well
How do I add a column to an existing table in db2?
What is null indicator in db2?
What is ibm db2 client?
What is ibm db2 used for?
What is a db2 cursor?
What is the use of reorg in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Define data page.
Is db2 free?
What is catalog database in db2?
What is the physical storage length of date data type?
What is reorg?
What is the use of runstats in db2?
Mention the downsides of page level lock.
