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 sqlcode -922 ?
What are common abends
How to get Top 10 Salaries from a Table
Is ibm db2 free?
can i code union in cobol-db2 pgm ?
When reorg is used?
What is the purpose of using commit?
what is a corelated subquerry?
what is a plan and how do you refer the plan in the program?
Explain about dbrm.
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
What does db2 blu stand for?