=?Utf-8?Q?_How_to_optimize_LIKE_=E2=80=99%MySea?= =?Utf-8?Q?rchString=E2=80=99?=

=?Utf-8?Q?_How_to_optimize_LIKE_=E2=80=99%MySea?= =?Utf-8?Q?rchString=E2=80=99?=

Post by TUw » Fri, 14 Jul 2006 21:15:02


What kind of data is in that column? Could you give a few examples?


ML

---
http://www.yqcomputer.com/
 
 
 

=?Utf-8?Q?_How_to_optimize_LIKE_=E2=80=99%MySea?= =?Utf-8?Q?rchString=E2=80=99?=

Post by Um9iUm9tY » Fri, 14 Jul 2006 21:48:01

The data type is NVARCHAR(50) and the columnn contains article names with
spaces, hyphens etc. There are about 370.000 rows in that table and also if
the resultset contains only some rows (e.g. 20) an Index Scan is done (using
a query with LIKE '%xxx' or LIKE '%xxx%').

 
 
 

=?Utf-8?Q?_How_to_optimize_LIKE_=E2=80=99%MySea?= =?Utf-8?Q?rchString=E2=80=99?=

Post by T21uaWJ1en » Fri, 14 Jul 2006 21:55:02

boy.. that's one helluva suggestion :)
--
-Omnibuzz (The SQL GC)

http://www.yqcomputer.com/