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
- 16165 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
How to take backup of table in db2?
What is deadlock in db2?
What is db2 purescale?
How do we specify index to include or not during bind process.
B37 abend during spufi?
How to check sequence on a table in db2?
How is the value function used?
What is explain plan in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
How do I add a column to a table in db2?
What is cascading rollback?
How does coalesce work?
What are catalog tables in db2?
What is performance tuning db2?
What is db2 instance?
