http://www.perlmonks.org?node_id=1015934


in reply to "Cannot use index" with DBD::SQLite

You don't need to tell SQLite which indexes do or do not exist ...

Replies are listed 'Best First'.
Re^2: "Can't use index" with DBD::SQLite
by LonelyPilgrim (Beadle) on Jan 29, 2013 at 22:51 UTC
    Apparently you do, since such is specified in the documentation, and since without the "INDEXED BY," the query takes a good 10-20 seconds to run, so it is clearly not using the index. (Which may be yet another indication that my index was incorrectly created.)
[reply]

In Section Seekers of Perl Wisdom