On Fri, 11 Apr 2003 11:34:09 +0000 (UTC), Louis Kleiman wrote:

> a. have an external table with 1,000,000 rows.
> b. have a real FB table with same structure as external, but empty
>
> 1. insert into... select from external table=20
> 24.828 seconds
>
> 2. delete all rows from FB table; commit
> 3. create index on FB table; commit
> 4. alter index inactive; commit
> 5. insert into... select from external table=20
> 1:41.359 seconds
>
> then, just to make sure, ...
>
> 6. delete all rows from FB table; commit
> 7. drop index on FB table; commit
> 8. insert into... select from external table=20
> 23.015 seconds
>
> This sure looks like the index is getting updated, but I am just looking
> in from the outside.

Was there any - explicit or implicit - garbage collection of the deleted rows?


--
Aage J.