Igor Tandetnik wrote:
> 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.
>
You're sure that's all there is to it? I haven't been able to make
use of the EXPLAIN results.
Also, I don't know how to specify a date based on what would be an
INTERVAL in MySQL. How do you express dates that are older than 90 days ago?
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
