Hi,

Always been on Oracle, now I'm working on my first DB2 database (db2 udb 8.1 on aix)
It seems that the indexes are always created in the same tablespace than the related table and there is no tablespace keyword in the create index synthax.

Am I correct ?
Tables and indexes in the same tablespace, is that the way to go ?


TIA

Stephane Paquette
Administrateur de bases de données
Database Administrator
Standard Life
www.standardlife.ca
Tel. (514) 499-7999 poste 7470
stephane.[Email Address Removed] <mailto:stephane.[Email Address Removed]



DB2 & UDB email list listserv db2-l LazyDBA home page