I remember some months ago, when i was testing early releases of FB
1.5, i was surprised with the speed of INSERT statements (INSERT
INTO ... SELECT ...)

Now i am trying to insert the records from a table to another (just
about 60.000 records) and, after 30 minutes, the statement is still
running.

I tried the same statement in diferent boxes (windows/linux) and had
the same results on both. The table where i am inserting the data
has no triggers, calculated fields, etc... Just 4 indices, all on
INTEGER fields. Both tables are in the same database, and i am using
IBExpert to run the statement.

My FB version is 1.5 RC8, on both Windows and Linux machines.

While i was writing this post, i noticed that if i deactivate the
indices os the destination table the insert is almost instantly. Can
some indices affect the speed this much?

Thanks.