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?
You haven't described the table. Is there some kind of a date or timestamp field that is included in new records? Otherwise, how do you know when they were inserted?
A query has a temporarily stable (or consistent) database, inserts, deletes or updates that occur during the processing of that query (or its transaction block, if applicable) are ignored. I'm not sure if that answers your question.