New features

August 8th, 2006 by Peter Scott

One of the paragraphs in Powell’s DW tuning book was something on the lines of (and the book is not with me right now)

…features such as bitmap indexes, bitmap join indexes, index organised tables and cluster tables were introduced in previous [before 10g] versions of Oracle, they are legacy techniques and since then the query optimiser has been improved it may not be necessary to use these techniques in a new data warehouse…

The gist, if not the exact words. I am not sure that bitmap indexes have already been superseded but there is some truth in the concept that new features are introduced in each release of a database (and not just Oracle ones) and the open minded should always be prepared to experiment, measure, benchmark to see if the new is better for your circumstances than the old methods. Oh, and reading the release notes is good idea, too especially about depreciated features

Posted in Data Warehousing, Oracle Database |

Comments

  1. Andy C Says:

    August 8th, 2006 at 4:57 pm

    Do you mean features that are deprecated or just unappreciated ?
    :-)

  2. David Aldridge Says:

    August 9th, 2006 at 3:49 pm

    Huh. I trust that there is some qualification on why they might be regarded as “legacy”. They are all really to do with allowing different choices by the optimizer. If they were legacy then the optimizer wouldn’t use them, or there wpould be a better alternative.

    Odd stuff.

  3. Pete_S Says:

    August 9th, 2006 at 5:00 pm

    Odd in deed :-)