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.?
Answer Posted / 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 |
Post New Answer View All Answers
What is the use of dclgen in db2?
What is cursor stability in db2?
What is bind package and plan in db2?
What is the maximum No of rows per page?
Which is faster delete or truncate?
What is node in db2?
How to resolve deadlock issue
What is difference between rollback and commit?
Explain about rct.
Is db2 a database?
What does db2 blu stand for?
What are the different types of base tables?
What is commit in db2?
How many databases can be created inside an instance in db2 ?
What is access path in db2?