Re: In 10g, Identifying Tables for Reorg and Compression
From: Mladen Gogala <gogala.mladen_at_gmail.com>
Date: Sat, 18 Sep 2010 18:39:59 +0000 (UTC)
Message-ID: <i7311v$vu9$5_at_news.eternal-september.org>
On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:
Date: Sat, 18 Sep 2010 18:39:59 +0000 (UTC)
Message-ID: <i7311v$vu9$5_at_news.eternal-september.org>
On Sat, 18 Sep 2010 12:10:50 +0200, Gerard H. Pille wrote:
> Thank you for your advice, mr. Gogala. We've truncated all large tables
> and the results are astounding, the queries are fast as lightning. But
> we seem to have another problem now, in that they are not returning any
> rows, not even for a simple "select * from ...". After the truncate, is
> there something we have to do to enable selects again?
You should seek the mighty Oz and ask him for a brain.
-- http://mgogala.byethost5.comReceived on Sat Sep 18 2010 - 13:39:59 CDT