Re: oracle's indexing methods

From: <alanlee1_at_my-dejanews.com>
Date: Thu, 09 Jul 1998 14:28:07 GMT
Message-ID: <6o2k1o$u0l$1@nnrp1.dejanews.com>

When you have high selectivity for the column you might want to use B-tree index whereas when selectivity is low (like male/female) use bitmapped index.

Hope this helps.

Alan Lee
BSI Consulting
Houston, Texas

In article <35A4983D.9817F64F_at_cressoft.com.pk>, Umar FArooq <umar.farooq_at_cressoft.com.pk> wrote:
> hi!
> im searching for a comparison between oracle's various indexing
> techniques....ie B-trees vs bitmapped indexes ....
>
> more specifically im looking for scenarios in which each type of index
> is used and a comprison of the performance, storage and maintenance
> requirements of each type
>
> Thx.
>
> umar farooq
> umar.farooq_at_cressoft.com.pk
>
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Thu Jul 09 1998 - 09:28:07 CDT