what is main use of table space and index object?
please its urgent
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 db2 instance?
What is db2 bind process?
What are the two types of logging in the db2 database? Explain them.
What is the physical storage length of timestamp data type?
What is consistency token in db2?
Why select is not preferred in embedded sql programs?
Can we update view in db2?
How connect db2 database to datastage?
What type of database is db2?
What is the role of the data page in the db2 database?
Explain correlated sub-queries.
What is bufferpool in db2?
What is sqlca’s maximum length?
What is a cursor in programming?
Define predicate?