Why Are My Indexes Still Valid Solution (A Second Face) October 20, 2011Posted by Richard Foote in IOT, Oracle Indexes, Quiz, Secondary Indexes.
add a comment
I’ve been so busy lately, I just haven’t had any spare time to post.
For now, the quick answer to the last quiz is that the second table was indeed an Index Organized Table (IOT).
One of the nice benefits of an IOT is that when re-organised, unlike a Heap Table, all indexes remain valid, even the Secondary Indexes. I’ll explain why in my next post in the next few days. I’ll also explain why secondary indexes are one of the main disadvantages with IOTs as well.
Stay tuned !!