Angus March wrote:
> I have a table where I need to record the date of each insert.
> Sometime later I'll then delete all rows that were inserted more than
> 90 days ago. Is it possible to do this w/out performing a table scan?

Create an index on the date column.

Igor Tandetnik



_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Reply via email to