Re: 10gR1 new feature: "Enhanced Bitmap Index Performance"

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Fri, 16 Mar 2007 06:55:22 -0000
Message-ID: <WYWdnQD2ltrKomfYnZ2dnUVZ8tGqnZ2d@bt.com>

One of the points on the following blog entry answers your question. The index does not acquire a huge trail of "old" blocks as it used to with small updates before 10g.

http://jonathanlewis.wordpress.com/2006/12/19/mything-in-action/

-- 
Regards

Jonathan Lewis
http://jonathanlewis.wordpress.com

Author: Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"ErikYkema" <erik.ykema_at_gmail.com> wrote in message 
news:1173997250.201705.226080_at_y80g2000hsf.googlegroups.com...


> In the 10gR1 New Features overview (http://download-east.oracle.com/

> docs/cd/B14117_01/server.101/b10750/chapter1.htm) it says:

> "Enhanced Bitmap Index Performance and Space Management"

> Bitmap indexes now perform better and are less likely to be fragmented

> when subjected to large volumes of single-row data manipulation

> language (DML) operations.

>

> I have not been able to find any docs in Google, Groups or Metalink

> that explicitly give more details about this specific "announcement".

>

> Any clues?

> Thanks, Erik Ykema

>

Received on Fri Mar 16 2007 - 01:55:22 CDT