As title, pay attention to the article 1000 is check recently, don't consider using ruwnum + order by (because too slow), a creation time field are available in the table

CodePudding user response:

If there is no filter to filter out the data and direct sequence should be very time consuming,

Partition the table according to the time to try?

CodePudding user response:

Don't write the order by, cannot ensure that data is accurate,

If the data is written to frequent, time field is not enough, can consider from the column,

CodePudding user response:

Add delete selected conditions, if not delete selected conditions to be slow because it is a full table scan