4 ms·In a huge database, even a SELECT with no WHERE clause can tie up considerable resources.by jtbigwoo 16y agoIn a huge database, even a SELECT with no WHERE clause can tie up considerable resources.dasil003 16y agoYou can kill it though, use SHOW PROCESSLISTdeleted 16y ago[deleted]neilk 16y ago--i-am-a-dummy also limits the number of rows you can SELECT or JOIN.