Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Please help me solve this Oracle mystery...
If the indexed columns of the small table is often updated,
the index will be much slower than a full table scan.
Indexes can only add nodes and mark outdated nodes as
such. the trick is ALTER INDEX indexname REBUILD.