Re: Oracle 8i info

On Thu, 24 Mar 2005 18:32:48 +0100, Sauro <sauro_at_despammed.com> wrote:

>Hello,
>can somebody help me. I use Oracle 8i version, I insert about 1.500.000
>records in a table, and, naturally, performance access decrease.
>After I delete all records of this table. This, using a Powerbuilder 10
>datawindow.
>But, even, with no records present, on this table access performance
>still be slow. Not as if records was presents, but more slow then
>records was not already be present.
>Thank you for any help about.
>Sauro

You must be conducting full table scans against the affected table. Full table scans always proceed upto the High Water Mark of the table. The HWM is NOT reset as a result of a delete. It is reset as a result of TRUNCATE.
Warning: TRUNCATE is a DDL command.

--
Sybrand Bakker, Senior Oracle DBA