Originally posted at 12/3/2010
One of the things that are coming to NH Prof is more smarts at the analysis part. We now intend to create a lot more alerts and guidance. One of the new features that is already there as part of this strategy is detecting bad ‘like’ queries.
For example, let us take a look at this
This is generally not a good idea, because that sort of query cannot use an index, and requires the database to generate a table scan, which can be pretty slow.
Here is how it looks like from the query perspective:
And NH Prof (and all the other profilers) will now detect this and warn about this.
In fact, it will even detect queries like this: