IOT Question - Which Tablespace? Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: IOT Question - Which Tablespace?

  1. #1
    Join Date
    Sep 2001
    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...

  2. #2
    Join Date
    Nov 2000
    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
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Click Here to Expand Forum to Full Width