Re: Index rebuild

Satish Narasimha wrote:
>
> Hello,
>
> I read in one of the article that if you want to have index rebuilt we need
> not use
> Alter index.....REBUILD, instead if we execute select count(*) from <tabname>
> will
> rebuild the index.
>
> Can anybody clarify how exactly this works.....
>
> from
> Satish. N.

Simple, it's not possible.
A select (*) does everytime a fulltable scan without touching the index in any way. There's no kown oracle-feature (to my knowledge) which can do
any kind of insert, updates or deletes during a select statement, and that's just what should happen to change the index. To rebuild an index there are only 2 methodes, 1) alter index rebuild
2) drop index and then create index.

rgds
eugen Received on Fri Feb 20 1998 - 00:00:00 CST