Digital Marketing

Creating sort index in MySQL

'Creating sort index' is the database figuring out the order of the returned values based on ‘order by’ clause. Main resources limit here would be available CPU and memory. The sort won't be done until the data is already all in memory if the result is small.

Adding suitable index could make the query faster.

Popular posts from this blog

How to fix Google Apps Script: Script function not found: doGet

How to fix: df shows no file systems processed on Linux