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

What does sqlcabc has?

825


What is role in db2?

840


How do I optimize a query in db2?

859


What is difference between alias and synonym in db2?

879


How do you simulate the explain of an embedded sql statement in spufi/qmf?

871


What is buffer pool and list some of them?

828


What is the role of union all and union

891


What is syscat in db2?

793


What is nvl in db2?

847


can we view the access paths created by dbrm ? how ? thx

6704


How does db2 sample database connect?

804


What is the advantage in De-normalizing tables in DB2?

966


How do you stop a db2 database in linux?

784


Is schema the same as database?

861


What is the physical storage length of timestamp data type?

885