-
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
-
No truth to any of it. How the data are accessed and modified are the key considerations.
-
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
-
Thanks for the replies and advice.
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
|