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 |
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Explain db2.
How to resolve the -305 error code in DB2? And also please let me know, how to resolve the db2 error codes.
What kind of database is db2?
What is phantom read in db2?
what is utility for parm lib
What is isolation level in db2?
Explain the contents that are a part of dclgen.
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?
what types of copies can be made with the COPY Utility ?
What information is used as input to the bind process?
How to check table size in db2 sap?