Optimized MySQL queries
Be more specific in your queries, for example, prefer
SELECT Column1, Column2 FROM TableName;
SELECT * FROM TableName;
select distinct, instead, opt for selecting additional columns to ensure you get distinct results. Select distinct does a lot of processing.
When using wildcards, make sure they are at as much end of the text as possible. If they are at the beginning then the database engine needs to search more.
SELECT * FROM TableName WHERE COLUMN LIKE 'texttofind%';
LIMIT to limit the number of records database engine needs to return.
The where clause creates a CROSS JOIN which is all possible combination of variables and then filters those to find the records which match the query.
The inner join matches only those records where the ids match and only those are returned from the query.
Both statements lead to the same results, but UNION can combine the result set of multiple queries and it runs faster.
Index all columns used in
ORDER BY &
GROUP BY clauses.