=?Utf-8?Q?How_to_optimize_LIKE_=E2=80=99%MySearchS?= =?Utf-8?Q?tring=E2=80=99?=

=?Utf-8?Q?How_to_optimize_LIKE_=E2=80=99%MySearchS?= =?Utf-8?Q?tring=E2=80=99?=

Post by Um9iUm9tY » Fri, 14 Jul 2006 21:06:02


Hello!

I using a statement with LIKE in the WHERE clause. Searching for rows
containing a prefix (LIKE yPrefix% SQL Server seeks the index on that
column that fine. But if I want to search for a suffix (LIKE MySuffix
an Index Scan is used and takes very long. Do I have any possibility that SQL
Server does an Index Seek in case of LIKE MySuffix

How can I optimize such a query?

I also couldn find a use of FTS in this case, because CONTAINS only
provi<es a but not a term for suffixes or am I wrong?

Thank you all!
 
 
 

1. =?Utf-8?Q?Command_Button=E2=80=99s_=E2=80=98back_color=E2=80=99?=

2. =?utf-8?Q?_Ballmer:_=E2=80=98Windows_7_will_be_?= =?utf-8?Q?Vista=2C_but_a_lot_better=E2=80=99?=

Frank cant you get it through your tiny whinny small brain?

I am clearly not an MS hater.

I like XP and am longing for windows7 to be far better than vista.

This logic dictates that something IS VERY WRONG with VISTA in order for me
to (not "hate" it but) ridicule and criticize it so much.

Perhaps its some stuff you are too dumb to comprehend????

I have sure told them to you! Yet you are too stupid to understand...

it is my fault?

3. =?Utf-8?Q?=22The_data_file_=E2=80=98Personal_Folder=E2=80=99?= =?Utf-8?Q?_was_not_closed_properly.=22?=

4. =?Utf-8?Q?The_instruction_at_0x00aa96bc_re?= =?Utf-8?Q?ferenced_memory_at_=E2=80=980x0000000=E2=80=99.?=

5. =?Utf-8?Q?_Unrecognized_database_format?= =?Utf-8?Q?_=E2=80=98C: \Trading_System=E2=80=99?=

6. =?Utf-8?Q?_ALTER_TABLE_xx_ADD_coly_=E2=80=98Che?= =?Utf-8?Q?ck_box=E2=80=99=3F=3F?=

7. =?Utf-8?Q?Error_Message:__=E2=80=98Argument_Not_op?= =?Utf-8?Q?tional=E2=80=99?=

8. =?Utf-8?Q?Server_error:_The_URL_=E2=80=98docs/=5Fvti?= =?Utf-8?Q?=5Fbin=E2=80=99?=

9. =?Utf-8?Q?ALTER_TABLE_xx_ADD_coly_=E2=80=98Check_b?= =?Utf-8?Q?ox=E2=80=99=3F=3F?=

10. =?Utf-8?Q?Query_to_Include_cboSymbols_or_=E2=80=98?= =?Utf-8?Q?*=E2=80=99?=

11. =?Utf-8?Q?IMediaControl::Run_fails_when_us?= =?Utf-8?Q?ing_=E2=80=98WM_ASF_Writer=E2=80=99?=

12. =?Utf-8?Q?Addon:_IMediaControl::Run_fails_?= =?Utf-8?Q?when_using_=E2=80=98WM_ASF_Writer=E2=80=99?=

13. =?Utf-8?Q?ActiveX_EXE_as_server;_second_cl?= =?Utf-8?Q?ient_crushes_with_Error_=E2=80=98462=E2=80=99?=

14. =?Utf-8?Q?Help_with_=22Run-time_error_=E2=80=98438=E2=80=99:?= =?Utf-8?Q?=22?=

15. =?utf-8?Q?Ballmer:_=E2=80=98Windows_7_will_be_Vist?= =?utf-8?Q?a=2C_but_a_lot_better=E2=80=99?=