Thank you SO MUCH for the replies, I am trying to take it all in.

Let me describe a little bit about why the data is deleted so regularly and why it's important to not slow down insert speeds.

Imagine 1000 searches being performed at one time, and as soon as the search is done, it collects the data and inserts the data into the TFX_v2_unfilteredrates table. The reason we need this to happen quickly is because we have a massive amount of searches to complete, and since the data needs to be FRESH it needs to be collected within 1 day.

The reason for deleteing the data is merely to keep the size of the table down to a workable size. Since I believe our queries are poorly written........

-Josh