I have an Oracle flat table that grew to just below 800MB. The table was truncated and new records are being inserted. Currently there are <40 records in the table but a
select * takes >30secs.
Could this be because the table is still so big (~800MB) that it is taking so long?
There are no indexes.
I found out from the person that cleared the table that they did a
delete instead of a