Sim Zacks wrote:
(quoting someone:)That LIKE operator is probably your problem. An unbounded LIKE like that (with a wildcard on both sides) means no index can be used, hence you get a sequential scan.
Was the message to which you responded posted to the newsgroup? It isn't appearing in my newsreader.
Who wrote the message you quoted (you failed to cite the source)? -- Lew
