Re: [PERFORM] Regarding Bitmap Scan

2006-10-27 Thread soni de
Thanks a lot for your help.   Thanks, Soni  On 10/17/06, Dawid Kuroczko <[EMAIL PROTECTED]> wrote: On 10/17/06, soni de < [EMAIL PROTECTED]> wrote:   I didn't understand the "Bitmap Scan" and the sentence "indexes will be dynamically converted to bitmaps in memory". What does mean by "Bitmap Sc

Re: [PERFORM] Regarding Bitmap Scan

2006-10-17 Thread Dawid Kuroczko
On 10/17/06, soni de <[EMAIL PROTECTED]> wrote:  I didn't understand the "Bitmap Scan" and the sentence "indexes will be dynamically converted to bitmaps in memory". What does mean by "Bitmap Scan" in database?   Can anybody help us regarding above query? Assume you have a table: CREATE TABLE

Re: [PERFORM] Regarding Bitmap Scan

2006-10-17 Thread A. Kretschmer
am Tue, dem 17.10.2006, um 17:09:29 +0530 mailte soni de folgendes: > I didn't understand the "Bitmap Scan" and the sentence "indexes will be > dynamically converted to bitmaps in memory". What does mean by "Bitmap Scan" > in > database? For instance, you have a large table with 5 indexes on thi

[PERFORM] Regarding Bitmap Scan

2006-10-17 Thread soni de
Hello,   I was going through the Performance Enhancements of 8.1.0, in that I have read "Bitmap Scan"   "Bitmap Scan: indexes will be dynamically converted to bitmaps in memory when appropriate, giving up to twenty times faster index performance on complex queries against very large tables. This