I've moved...

This blog now has a new home - please update your shortcuts and readers to: www.jeffkemponoracle.com. Sorry for any inconvenience!

Thursday, January 17, 2008

LIKE with wildcard (%) at start CAN use an index

A tester for our client raised a problem where searches like 'ABC%' would perform satisfactorily, but searches like '%ABC' would time out. Of course, the reason is that the index on the column cannot be used if a wildcard is at the start of the string, so a full table scan is always performed.

[Full Article]

No comments:

Post a Comment

Note: only a member of this blog may post a comment.