SELECT *

[Benjamin Bach]

Dear *.*,

I'm having some great big troubles making a demonstration of how my company could benefit by migrating from SQL Server to MySQL.

The issue is SELECT * and ORDER BY RAND() which can take a couple of seconds to execute on a 19 MB table.

"EXPLAN SELECT * FROM big_table" tells me that no indexes are used.

I'm using MyISAM and have told my.cnf to consume alot of memory.

BTW: This query is really fast:

SELECT col1, col2, col3 (...) FROM big_table

EXPLAIN also tells me that it uses indexes. So I guess the real issue is how to deal with SELECT * which is all over our website.