Re: Index Leafs don't empty on delete why pls help....

From: sybrandb <sybrandb_at_yahoo.com>
Date: 12 May 2006 02:38:04 -0700
Message-ID: <1147426684.704213.23060@v46g2000cwv.googlegroups.com>

The entries will be re-used if the associated keys return. If the associated keys never return (as they are surrogate and ever increasing) you could consider using reverse key indexes. Other than that: yes eventuall you should rebuild.

-- 
Sybrand Bakker
Senior Oracle DBA

Received on Fri May 12 2006 - 04:38:04 CDT

This message: [ Message body ]
Next message: Thiko!: "startup oracle 10g as oppposed to 9i create database"
Previous message: Jörg Menker: "Re: How to optimize for this?"
In reply to: peter: "Index Leafs don't empty on delete why pls help...."
Next in thread: Carlos: "Re: Index Leafs don't empty on delete why pls help...."
Reply: Carlos: "Re: Index Leafs don't empty on delete why pls help...."

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US