Re: Defragmenting table

Hi,

>
> In my case i have found it more efficient to use count(rowid) rather
> than row(*), but i don't think that the savings are worth the effort.
> Florent

I did some tests with autotrace on and found no difference. I had the same problem with a table grown very large and than every row was deleted. So a select count(*) returned 0 but it took more than 6 seconds to return.
After a truncate table it was much faster. But this won't really help in your case :-)

Regards

Dirk Mika

-- 
Bayer AG
WD-AED /LEV
D-51368 Leverkusen
Telefon: +49 (214) 30-50360
Telefax: +49 (214) 30-20031
Email  : dirk.mika.dm1_at_bayer-ag.de