> I have a situation where I delete all records in a table and then I
> drop the index on that table.
> The sql is
>
> delete from Table;
> drop index Table_Index;

First drop the index, then delete the rows.
Otherwise you can unnecessarily slow things down.

Ivan