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 |
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is the use of dclgen in db2?
What is RUNSTATS?
What is host variable in db2 cobol?
Is schema the same as database?
What are the benefits of using the db2 database?
What are union and union all?
What is PRIME TABLE and what are the uses of it
How is deadlock resolved?
Can we able to find all the Table names under a Particular Plan?
What is the syntax of SELECT statement when embedded in a COBOL program?
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?