Difference between IOT, B-Tree and Bitmap index
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Difference between IOT, B-Tree and Bitmap index

  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