RE: bitmapped indexes

2003-01-14 Thread Khedr, Waleed
The paper says performance is good but concurrency is a problem: "Depending on the cardinality of data, this may mean locking several thousand rows at once. For this reason, it may not be a good idea to use bitmap indexes for environments where high levels of concurrent updates to the base data ar

RE: bitmapped indexes

2003-01-14 Thread Naveen Nahata
Title: RE: bitmapped indexes Oops! I had just saved it to be read later. When i try to open it says, 'Corrupted File'   Sorry for the confusion   Regards Naveen -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 8:15 PMTo

Re: bitmapped indexes

2003-01-14 Thread Igor Neyman
Title: RE: bitmapped indexes you sure, you got it?   Igor Neyman, OCP DBA[EMAIL PROTECTED]      - Original Message - From: Naveen Nahata To: Multiple recipients of list ORACLE-L Sent: Tuesday, January 14, 2003 8:34 AM Subject: RE: bitmapped indexes But i

RE: bitmapped indexes

2003-01-14 Thread Hately, Mike (NESL-IT)
It's from a paper called "Bitmap Indexing in Oracle7.3 and 8.0" which is available at http://www.newagetraining.com/library/ora_dev/sql_plsql/script/BitmapIndexes .pdf The theory is true in relation to data loads r

RE: bitmapped indexes

2003-01-14 Thread Naveen Nahata
Title: RE: bitmapped indexes But i got the attachment.   AFAIK, listguru filters attachments, How did i get it then?   Regards Naveen -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 6:24 PMTo: Multiple recipients of list

RE: bitmapped indexes

2003-01-14 Thread Jamadagni, Rajendra
Title: RE: bitmapped indexes It was filtered by Listguru ... where did you get it from? Maybe we can pick it up at the source ... Raj __ Rajendra Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion

RE: bitmapped indexes

2003-01-14 Thread Andrey Bronfin
Hi ! I don't remember where I got the paper, but I am attaching it. Cheers. -Original Message- Sent: ? 13 ? 2003 19:40 To: [EMAIL PROTECTED]; Andrey Bronfin Andrey, Perhaps you could tell us what paper, and where to obtain it. >From the context, it sounds like a reference to phy

Re: bitmapped indexes

2003-01-13 Thread Jared Still
Andrey, Perhaps you could tell us what paper, and where to obtain it. >From the context, it sounds like a reference to physical modifications rather than DML. Jared On Monday 13 January 2003 07:54, Andrey Bronfin wrote: > Dear gurus ! > A ( maybe ) stupid question : I always thought that bitma

Re: bitmapped indexes

2001-06-28 Thread Stephane Faroult
Valiveru, Siva wrote: > > Need a advice here .. > > Table "A" > > Col1 - PK > Col2 - Low cardinality column ( say 2 or 3 distinct values) > Col3- Low cardinality column > col4- Log Cardinality column > > which of the following options is appropriate for the queries like this( > Ours is a high