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...
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.
"I pledge to stop eating sharks fin soup and will not do so under any circumstances."