Re: problem with a query

This is almost completely untrue.

You need to specify much more carefully
how you are using the index before you
hit the circumstances where this is
nearly true.

--

Jonathan Lewis
Yet another Oracle-related web site:  http://www.jlcomp.demon.co.uk

John Gasch wrote in message <38EB98AB.35791841_at_erols.com>...


>When rows are deleted from a table, the index slots are merely marked as

>"deleted".  If the index is on a monotonically increasing data value,

>such as a sequence number, then the index will grow without bound over

>time because the deleted slots won't get reused.  The periodic rebuild

>works because it reclaims the space from the deleted rows.

>