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
- 15935 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
Why db2 is called db2?
What is the difference between spufi and qmf?
What is the difference between nvl and coalesce?
What is page size in db2?
What are the 2 sqlcodes that are returned?
How and when does the db2 enforces the unique key?
What's The Percentage Free Space ?
Explain correlated sub-queries.
Define data page.
How many types of page locks can be held in db2?
What are catalog tables in db2?
What is a system catalog table in db2?
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
What are the various isolation levels possible?
What language is db2 written in?
