DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2001
    New York , New York

    Whats the difference between an Index Oraganized table, a Table with a Btree Index and one with a bitmap Index.

    Under what circumstances should each be used ??



    You can if you think you can.

  2. #2
    Join Date
    May 2002
    Article on IOT's:

    From Oracle8i DBA Bible by Gennick -

    B*Tree indexes:
    Good choice for most uses as they
    -maintain the sort order of the data, making it easy to look up range data
    -multicolumn indexes: you can use the leading edge columns to resolve a query, even if that query doesn't reference all columns in the index
    -they automatically stay balanced
    -performance remains relatively constant
    - can also specify reverse and unique

    Bitmapped indexes:
    -use them to index columns with that contain a relatively small number of distinct values
    -they are compact, saving space
    -were designed for query intensive databases, so not recommended for OLTP databases
    -not good for range scans
    -are available only in Enterprise Edition

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

We have made updates to our Privacy Policy to reflect the implementation of the General Data Protection Regulation.