out of memory

? A statement like 'Select * from Tiger_main limit 1,1' is very slow, and iterating over the entire table would take weeks. I am using MySQL server version 3.23.36 under RH Linux 7.1. Thanks for any support you can offer. David Keeney -- David Keeney [EMAIL PROTECTED] Travel

out of memory

can offer. David Keeney --- End of forwarded message --- -- David Keeney [EMAIL PROTECTED] Travel By Road http://www.travelbyroad.net - Before posting, please check: http://www.mysql.com

Re: Indexing, Perl DBI

and diagnose the problem. Thank you David David Keeney [EMAIL PROTECTED] Travel By Road http://www.travelbyroad.net - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Index use, Perl DBI

and recreating the index to no avail, and have dropped other indexes that I thought might possibly be confusing the optimizer. No improvement. Is there a way, through the Perl DBI interface, to determine whether a given SELECT query is using indexes? Thank you for any assistance offered. David Keeney