-
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.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|