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
- 16336 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
What is an instance database?
List out the buffer pools in db2
Mention data types used in db2 ?
What is universal database?
What is the reason behind not using select * in embedded sql programs?
What does sqlcabc has?
Can we delete records from view?
What is consistency token in db2?
How to check sequence on a table in db2?
Explain dclgen.
What is release/acquire in bind?
Explain about open switch business continuity software?
What happens in bind step in a db2 program?
What is the maximum No of rows per page?
Is db2 a database?
