Tim Romano <[email protected]> wrote: > My update query has been running for 45 minutes, and I'm not sure how > to stop it. I think it's selecting a row from a table with 25,000 > rows 4 million times rather than selecting a row from a table with 4 > million rows 25,000 times. > > To prevent this in the future, I need to learn more about how to > interpret the results of EXPLAIN.
Try EXPLAIN QUERY PLAN instead. Most of the time, it'll tell you all you need to know. Igor Tandetnik _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
