which is the most efficient tablespace??
a.simple tablespace.
b.partitioned tablespace.
c.segmented tablespace.
d.none of the above.
please post answer with the reason.?
Answers were Sorted based on User's Feedback
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / jaydeep c
C. Segmented tablespace.
Because the sequential access to a particular table is more
efficient and the mass delete is much more efficient than any
other tablespace.
Is This Answer Correct ? | 0 Yes | 0 No |
WHAT IS MEANT BY COMMIT COMMAND?
if one db2 pgm calls another db2 pgm. how many plans do we need. what r the steps involved..
What are the disadvantages of PAGE level lock?
Define predicate?
What are delete-connected tables?
What is the max length of sqlca?
What is a DB2 access path?
how do u update the faltfile into db2 table ?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What information is held in SYSIBM.SYSCOPY?
How to test SQL -911 error while developing COB-DB2 program
How many buffer pools are available in db2?