what is main use of table space and index object?
please its urgent
- 5 Answers
- 13936 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 copy pending and check pending in db2?
What is db2 bind process?
How can you classify the locks in db2?
How to find the maximum value in a column in the db2 database?
What are the various isolation levels possible?
How can the duplicate values be eliminated from db2 select?
My sql statement select avg(salary) from emp yields inaccurate results. Why?
What is a db2 table?
What is bind and rebind in db2?
Explain package in db2 and its advantages?
What is the default page size of buffer pools?
Explain how can you do the explain of a dynamic sql statement?
How would the varchar column remarks defined?
What is check constraint. Explain with example.
What are foreign keys in db2?
