what is main use of table space and index object?
please its urgent
- 5 Answers
- 14021 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
How to access db2 tables in mainframe?
What is coalesce in db2?
What is the syntax for creating a table in the db2 database?
How to view db2 table structure?
What is the difference between drop table and delete table?
What does db2 stand for?
What is the maximum size of a char data type in db2?
define clustering index.
What is a db2 cursor?
What do you mean by storage group (stogroup)?
Mention the downsides of page level lock.
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is dbrm in db2 database?
If I have a view which is a join of two or more tables, can this view be updateable?
What is the meaning concurrency in the db2 database?
