What are simple, segmented and partitioned table spaces ?
Answer Posted / s
Simple tablespaces stores the rows for all the tables and
they are interleaved with one another.
Segmented tablespaces, tables are stored in equal sized
segments and a segment contains rows from one table.
Partitioned tablespace, only one table can be defined and
rows are spread across partitions.
Is This Answer Correct ? | 6 Yes | 1 No |
Post New Answer View All Answers
What is page size in db2?
What is dbrm? When it will be created?
What is a bind in db2?
What is the max length of sqlca?
What's The Percentage Free Space ?
Mention some fields that are a part of sqlca.
What is load replace in db2?
What is query_cache_limit?
What is a plan and package in db2?
Is db2 a programming language?
What does reorg do in db2?
Which component is used to execute the sql statements?
What is a db2 package?
Can one database have multiple instances?
Mention the location where the output received from explain statement is stored.