Re: Index rebuild

Satish Narasimha (satishn_at_blr.sni.de) wrote:
: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.

It does not.

"select count(*) from <table>" does not change anything in the database. It performs a full table scan, counts the number of rows, and returns that count. That's all it does.

-- 
-bn
random_at_interaccess.com	(PGP 2.6.2 public key available on request)
"There is no .signature -- only ZUUL!"