what is main use of table space and index object?
please its urgent
- 5 Answers
- 14042 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 does sqlcabc has?
How to resolve deadlock issue
Which component is responsible for processing sql statements and selecting access paths?
What is dclgen (declaration generator)?
What db2 400?
What is deadlock in db2?
What parameters are used to control the free space in DB2?
How to rename a table in DB2 ?
What is a db2 schema?
What is ibm db2 client?
Explain the function done by data manager?
How to run db2 command in windows?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are 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?
Explain the function of data manager.
