DBIx::AssertIndex - show error when SQL query doesn't use index.
use DBIx::AssertIndex; my $row = $dbh->selectrow_hashref(q{SELECT * FROM some_table WHERE no_indexed_column = 'foo'}); or > starman -MDBIx::AssertIndex app.psgi
DBIx::AssertIndex is run explain with SELECT SQL and detect query without any index.
Works only DBD::mysql.
daichi hiroki <daichi.hiroki@mixi.co.jp>
This library is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
To install DBIx::AssertIndex, copy and paste the appropriate command in to your terminal.
cpanm
cpanm DBIx::AssertIndex
CPAN shell
perl -MCPAN -e shell install DBIx::AssertIndex
For more information on module installation, please visit the detailed CPAN module installation guide.