Showing entries 1 to 1
Displaying posts with tag: table scan (reset)
Nov
23
2010
MySQL Query Optimization – Tip # 1 – Avoid using wildcard character at the start of a LIKE pattern.
Posted by Ovais Tariq on Tue 23 Nov 2010 13:53 UTC
Tags:

The more I go through others SQL, there are some common mistakes that I see developers making over and over again, so I thought why not start a series of tips that can help developers optimize their queries and avoid common pitfalls. So this post is a part of that series of tips, and this is the first tip "Avoid using a wild card character at the start of a LIKE pattern".

Showing entries 1 to 1