what is main use of table space and index object?
please its urgent

Answer Posted / venu

Table Spaces are phsysical spaces where the tables are
created. Index spacesa are automatically created when
indexes are created, indexes are stored in index spaces.

Is This Answer Correct ?    16 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected

10722


What is precompiler in db2?

579


What kind of database is db2?

563


Why do chiropractors use drop table?

647


Comment whether dclgen is mandatorily used. If not, then what is the point of using it?

598






What is a storage group (stogroup)?

766


What is plan in cobol db2?

580


What is ibm db2 connect?

566


How will you return the number of records in table?

508


have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.

1225


Where can you declare a cursor in a cobol-db2 program?

596


How would you find out the total number of rows in a db2 table?

570


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

2262


What is cloudant database?

636


Which is faster delete or truncate?

667