Software

Ask something
Discussion Locked

Delete statement in stored procedure

0 helpful
1 reply

by info

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.
Is there any optimization that could be done to a stored procedure that deletes millions of rows from an Oracle database based on some date criteria?

1 reply

by jmiller1

That all depends on your table structure (indexes, etc), the SQL statement you are running to delete the rows, lots of different factors. Need some more information in order to analyze.

This discussion is closed to new replies.