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


Please Help Members By Posting Answers For Below Questions

What is db2 instance?

817


What is db2 bind process?

953


What are the two types of logging in the db2 database? Explain them.

809


What is the physical storage length of timestamp data type?

863


What is consistency token in db2?

877


Why select is not preferred in embedded sql programs?

955


Can we update view in db2?

775


How connect db2 database to datastage?

997


What type of database is db2?

720


What is the role of the data page in the db2 database?

787


Explain correlated sub-queries.

777


What is bufferpool in db2?

817


What is sqlca’s maximum length?

904


What is a cursor in programming?

834


Define predicate?

875