Are you sure that the SQL is going to return half a million rows as per the explain plan?

When you executed the query, how many rows did the SQL return? And what's the run time?