constantly updated table in Amazon RDS

Hello,

A table is constantly updated by inserting new rows. Will it affect select if where clause is based on > date?

Does "where clause" to specify > date and < now?

Thanks!