my question is simple, can ORDER BY improve a query speed and performance when we are searching for a number using an indexed field?
Or it doesn't matter for mysql?
i explain better:
so looking at this query:My Table wrote:CREATE TABLE `serverplayer` (
`id` int(10) unsigned NOT NULL,
`status` tinyint(3) unsigned NOT NULL DEFAULT '0',
`serverid` int(10) unsigned NOT NULL,
`jointime` int(10) unsigned NOT NULL DEFAULT '0',
PRIMARY KEY (`id`),
KEY `serverid` (`serverid`),
CONSTRAINT `serverplayer_ibfk_1` FOREIGN KEY (`id`) REFERENCES `users` (`id`) ON DELETE CASCADE,
CONSTRAINT `serverplayer_ibfk_2` FOREIGN KEY (`serverid`) REFERENCES `server` (`id`) ON DELETE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_unicode_ci
Code: Select all
SELECT * FROM serverplayer WHERE serverid = 525 ORDER BY serverid LIMIT 20Code: Select all
SELECT * FROM serverplayer WHERE serverid = 525 LIMIT 20Since ORDER BY put all serverid in order it will be more fast for mysql search and select?
Thanks