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 |
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
if any of the column names is provided wrong, where do you get the error(during precompilation or during Bind)
What is db2?
Mention and explain the contention situations caused by locks?
What is drop table?
What is a db2 tablespace?
List out the three types of page locks that can be held.
How can you get the number of rows impacted by the last executed query?
What is a storage group (stogroup)?
What is -904 sql code? How to resolve it?
what is the soft code for deadlock ?
i have a table like this : Name ADDRESS Toto 123 ... Toto 456 ToTo 678 I would like to delete 2 last row...please tell me how to delete its