Interested to Buy Any Domain ? << Click Here >> for more details...
what is main use of table space and index object?
please its urgent
- 5 Answers
- 16126 Views
- CA, Cap Gemini, CGI, CTS, EDS, HTC, IBM, Satyam, Syntel, TCS, Wipro, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
>>Tablespace is one of the subdivision of Database in DB2.
Tables are created in Tablespaces.Indexspace is also a
subdivision of Database which contains indexes.
>>One imp difference is tablespace can contain one or more
tables whereas indexspace contains only one index for a table.
>>Tablespace has to be created by explicitly mentioning
create tablespace whereas indexspace is created implicitly
whenever we create an index using create index command.
>> Index is an object which can be considered as pointers to
rows of a table.
| Is This Answer Correct ? | 29 Yes | 0 No |
Post New Answer View All Answers
List out the data types available.
What db2 400?
How to find primary key of a table in db2?
Which component is responsible for db2 startup and shutdown?
Differentiate between cs and rr isolation levels? Where do you specify them?
How connect db2 database to datastage?
What does reorg do in db2?
Comment whether dclgen is mandatorily used. If not, then what is the point of using it?
What is dclgen in db2?
How do you eliminate duplicate values in db2?
What are the various isolation levels possible?
What is the maximum size of varchar data type in db2?
Explain the benefits you can get from mainframe connect?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What is meant by union and union all?
