Interested to Buy Any Domain ? << Click Here >> for more details...
what is main use of table space and index object?
please its urgent
- 5 Answers
- 16144 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 usage of open cursor command?
What is the latest version of ibm db2?
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain packages.
Discuss about db2 bind?
What is the use of db2 optimizer?
Explain the benefits you can get from mainframe connect?
What is difference between alias and synonym in db2?
Explain how can you do the explain of a dynamic sql statement?
Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?
Which isolation level provides highest data integrity?
Which command is used to remove all rows from a table?
How do I add a column to a table in db2?
What is dbrm in db2 database?
What is explain in db2?
