-
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
-
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.