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 cloudant database?
What is the information associated with sysibm.syslinks table?
What is bind plan?
If I have a view which is a join of two or more tables, can this view be updatable?
Can any one tell me about Restart logic in DB2.
What do you need to do before you do EXPLAIN?
Bind concepts in DB2 cobol
10 Answers IBM, TCS, TRD, Virtusa,
What are the advantages of using a PACKAGE?
how does the defining of a stored procedure effect the size of a DB2 data base A) it increases the size of a data base B) it decreases the size of a data base C) it does not effect the size of the data base D) it changes the table space structures
What do you mean by commit and rollback?
can we drop column from a table
What's the maximum number of characters that a tablename can have?