Not correct. Using DMS tablespaces allows you to have tables and indexes in different tablespaces. There are advantages (and disadvantages) to doing this. I'd suggest looking this up a little more.

-----Original Message-----
From: Stephane Paquette [mailto:stephane.[Email Address Removed] Tuesday, December 02, 2003 2:44 PM
To: DB2 UDB LazyDBA
Subject: Index versus tablespaces


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]




---------------------------------------------------------------------
PLEASE CLICK REPLY-ALL TO SEND A REPLY TO EVERYONE
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: db2udbdba-[Email Address Removed] additional commands, e-mail: db2udbdba-[Email Address Removed] e-mail transmission may contain information that is proprietary, privileged and/or confidential and is intended exclusively for the person(s) to whom it is addressed. Any use, copying, retention or disclosure by any person other than the intended recipient or the intended recipient's designees is strictly prohibited. If you are not the intended recipient or their designee, please notify the sender immediately by return e-mail and delete all copies.

---------------------------------------------------------

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