Interested to Buy Any Domain ? << Click Here >> for more details...
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.?
- 3 Answers
- 6523 Views
- I also Faced
- E-Mail Answers
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 ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is package in db2 mainframe?
What is database manager in db2?
What is the maximum size of a char data type in db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
What is db2 optimizer?
What is dbrm? What it contains?
What do you mean by storage group (stogroup)?
Explain about dbrm.
What is the physical storage length of date data type?
i tried to copy some records from microsoft excel to as-400 physical file through "Bosanova" emulation. Out of 14000 records only 12000 records copies and subsequently programe started to hang. Then, i closed the program forcefully. I did' under stand the problem. Also when i try to compile the physical file it is showing as "The file in use". How to overcome this problem?
What is the maximum length of sqlca?
How can the duplicate values be eliminated from db2 select?
What's The Percentage Free Space ?
What is the use of runstats in db2?
How to test SQL -911 error while developing COB-DB2 program
