Listers,
We are creating indexes on a 300m row fact table
today. I am researching bitmap versus btree (again) to
see where the latest info points.
Anyone care to comment on the way to determine whether
an index should be a btree or a bitmap? Anyone even
know a good way to test this?
thx,
/jac
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
I am on leave from May 29 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
akash
com> cc:
Sent by: rootSubject: Re: Bitmap vs btree - how to
tell?
how
amped.
Anand Prakash
com> cc:
Sent by: rootSubject: Re: Bitmap vs btree -
how to tell?
how to test?
05/24/2002
I am on leave from May 27 to July 15. Please contact Jaspreet Jajj at
x4338 for any query. Thanks.
Anand Prakash
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Anand Prakash
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-505
and Prakash
> list ORACLE-L @firsthealth.<[EMAIL PROTECTED]>
> com> cc:
> Sent by: root Subject: Re: Bitmap vs btree -
> how to tell? how to test?
>
>
low cardinality -- good candidate for bitmap. little or no updates to
the column being indexed -- good candidate for bitmap
"low" cardinality is relative -- 10,000 distinct values in a 300m row
table is low, 100 distinct values in a 10K row table might be high
but the main criteria I have found
On 2002.05.25 17:38 Rachel Carmichael wrote:
> low cardinality -- good candidate for bitmap. little or no updates to
> the column being indexed -- good candidate for bitmap
>
> "low" cardinality is relative -- 10,000 distinct values in a 300m row
> table is low, 100 distinct values in a 10K row