IOT Question - Which Tablespace?

[jcj88]

Which tablespace would you normally put an index-organized table?

For simplicity, let's say I have 2 tablespaces on separate disks: one for indexes and one for tables. Would you put it in the index tablespace or the table tablespace and why?

Or does it even matter?


Thanks in advance...
Jay

[marist89]

Depends on how it will be accessed. If it is accessed in a join with other tables, I would put it in the index tablespace. If the joins are using indexes of the other tables, I would put it in the data tablespace.