Hi everybody,

I'd like to delete records in all my stage tables which are prior to the certain date. My colleague suggested to use tEntered_Date field (we don't have an index on this field). I wrote a program using DELETE FOR command and it's still running.. (couple of minutes already).

I'm wondering, what should I do to make it quicker?

Thanks in advance.