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 |
For update of a row in cursors, when do we move value into host variable in cobol progrm? is it before open or before fetch ?
How to design maps
What is access path in db2?
How do you prepare a COBOL + DB2 program from coading till execution ?
What is the difference between plan and package in db2?
In my table having 100 Rec. How can I delete the 7th row?? (we don't know what is data inside the table)
What is FREEPAGE and PCTFREE in TABLESPACE creation?
What is -904 sql code? How to resolve it?
What is the physical storage length of time data type?
List out the data types available.
How is a typical DB2 batch program executed ?
how do you resolve -818 error in db2. where we have to see time stamp token. i said by seeing in load module and plan .is it correct or not. give clear explination for how to see time stamp token