Please help me.

Thanks, Wayne. I got answer from here,

http://stackoverflow.com/questions/6310417/is-this-possible-to-use-like-with-all-keyword

Thanks I will take a closer look in my Indexes

But the sql is different

For detail of tables see this thread

http://www.sqlservercentral.com/Forums/Topic988717-360-1.aspx

Thank you very much

I mean if I am using a column just for Joining to another table, It is worth to create an Index for this column.

What did...

Thank you very much Gail,

Is we create an Index for columns used for joining?

two filtering predicates (column = constant) are first in the index with the join column third. SQL...

I am not understand clearly.

I am using ,

where colA1=colB2 and colA2='abc' and colA3 ='xyz'

colA1 just used here to join with Table B.

Is the column at left most must be the...

Thank you very much Gail.

So you are saying I should go with second(INNER JOIN),

(Note: The third one will use Top 1 so that it will not fail(only fails if no...

Thank you very much Gail.

I really appreciate your help.

Thanks to all of repliers,

My problem is mostly solved by your tips and Gail Shaw articles about Indexing.

My query is now only takes longer time for one character searching.

Any tips...

/****** Object: Index [IX_BusinessData_CityState] Script Date: 09/23/2010 10:19:51 ******/

CREATE NONCLUSTERED INDEX [IX_BusinessData_CityState] ON [dbo].[BusinessData]

(

[CityState] ASC

)WITH (PAD_INDEX =...

There are only six rows in Industry table.

When I add a new index i get IndustryName, my execution time decline from 40 to 21 Sec.

But 21 Sec is also huge.

New...

Thanks Paul White NZ and Gail Shaw, After removing Hint and adding INCLUDE INDEX,

CREATE NONCLUSTERED INDEX [IX_SubCategoryNAICSCode] ON [dbo].[SubCategoryNAICSCode]

(

[NAICSCode] ASC

)

INCLUDE ( [SubCategoryID]) WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE ...