Hello Lowell,

Yes I have put indexes on all columns used in the query. So i'm down to 0.35sec

That is still way to long time.

Yes, there are two search terms, that...

Hello Lowell,

Thank your for your thoughts.

Here's some swedish websites you can check to see what I am trying to do.

http://www.hitta.se

http://www.allabolag.se

both sites are using two conditions, condition what and where and...

Thanks for your help, but I got it to work with JOINS.

Now I need help with optimizing it, it takes to long time to recieve all data.

// Daniel

I have searched on google, but didn't find anything.

I would a preciate if someone can give me a sample, or redirect me to a page.

BR

Daniel

How do you mean with "change your join to an in-statement with a sub-query".

Can you please give me a sample.

// Daniel

Here's the whole sp, maybe you will understand better:

set ANSI_NULLS ON

set QUOTED_IDENTIFIER ON

go

ALTER PROCEDURE [dbo].[sp_GetCompaniesByKeywords]

@KeyWhat varchar(150) = NULL,-- what to search for

@KeyWhere varchar(150) = NULL,-- where to search

@PageSize int...

No, I just want Company info like Company name, orgnumber only.

But you can search by address info like zipcode, street address etc.

but i haven't put that in the query yet,...