If the STATUS_ID column values are evenly distributed, index won't help performance. In this case, avoid using index.

You can use FIRST_ROWS hint in any SELECT statement.