DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: IOT - does size matter...

  1. #1
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204

    IOT - does size matter...

    Is there any truth to the rumor that Index Organized Tables should only be used for small tables?

    Is a single key column a good/bad candidate?

    Is there an advantage/disadvantage if the rest of the table (non-pk) has few or many columns?

    Ken
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

  2. #2
    Join Date
    Aug 2002
    Location
    Colorado Springs
    Posts
    5,253
    No truth to any of it. How the data are accessed and modified are the key considerations.
    David Aldridge,
    "The Oracle Sponge"

    Senior Manager, Business Intelligence Development
    XM Satellite Radio
    Washington, DC

    Oracle ACE

  3. #3
    Join Date
    Nov 2006
    Location
    Sofia
    Posts
    630
    Tables with many and large columns leads to less rows per leaf block. That increases the number of leaf blocks and hence, the necessary index height to cover these leafs. So generally the tables with large rows leads to higher and hence slower index.
    You should be more concerned about the row movement in case of key columns updates and the performance of the secondary indexes

  4. #4
    Join Date
    Mar 2002
    Location
    Mesa, Arizona
    Posts
    1,204
    Thanks for the replies and advice.
    "I do not fear computers. I fear the lack of them." Isaac Asimov
    Oracle Scirpts DBA's need

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