Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Jack Silvey
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

Re: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Anand Prakash
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

Re: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Anand Prakash
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

Re: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Thomas Day
akash com> cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how

RE: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Mercadante, Thomas F
amped. Anand Prakash com> cc: Sent by: rootSubject: Re: Bitmap vs btree - how to tell? how to test? 05/24/2002

RE: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Anand Prakash
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

Re: Bitmap vs btree - how to tell? how to test?

2002-05-24 Thread Jared Still
and Prakash > list ORACLE-L @firsthealth.<[EMAIL PROTECTED]> > com> cc: > Sent by: root Subject: Re: Bitmap vs btree - > how to tell? how to test? > >

Re: Bitmap vs btree - how to tell? how to test?

2002-05-25 Thread Rachel Carmichael
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

Re: Bitmap vs btree - how to tell? how to test?

2002-05-25 Thread Mladen Gogala
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