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 are the uses of db2 optimizer?
How do I start db2 in windows?
Is ibm db2 open source?
What is role in db2?
What is the connection string to connect to the DB2 Database ?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
What are bind parameters in db2?
What is db2?
What is ibm db2 client?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is host variable?
How to access db2 tables in mainframe?
How can tablespace be moved to another dasd volume that is allocated for that tablespace?
What is meant by union and union all?
Can we delete records from view?