Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
p2bl
Yak Posting Veteran
54 Posts |
 Posted - 2001-10-25 : 07:46:18
|
| Here's a table "table1" with a column "title" varchar(100),and Index on title coulmnthe table hav about 240,000 records.When I use followed query,it takes almost 6 seconds(by query analyzer)! select * from Table1 where title like '%something%'The analyzer told me it uses table scan not index seek,but when I use select * from Table1 where title like 'something%'Index seek was used.So how should I rewrite this sql?I must have a match search on column title.I do not know what is what |
|
|
|
|
|
how to make "like" faster?