what is main use of table space and index object?
please its urgent
- 5 Answers
- 15093 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 the syntax for seeing the columns and data types of a table in the db2 database?
What are the various data types available in db2?
Suppose pgm A calling Pgm B .Pgm B has some Db2 program. at the time of compilation should plan and package will be created for both A and B or only B? What is the concept?
What is the physical storage length of date data type?
Is db2 a mainframe?
Explain the function done by data manager?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is a cursor in programming?
what is diffrence b/w file-aid tool and file-aid utility???
What is bind and rebind in db2?
What does sqlcabc has?
What is node in db2?
What is a storage group (stogroup)?
What is the max length of sqlca?
How do I optimize a query in db2?
