On Tue, 26 Feb 2008 04:41:24 -0800 (PST), paankhate@googlemail.com
wrote:

> Hi,
>
>I have a task at hand to reduce the time taken for search query to
>execute. The query fetches records which will have to sorted by
>degrees away from the logged in user. I have a function which
>calculates the degrees, but using this in the search query slows the
>execution and takes about 10 secs to complete which is unacceptable.
>
>Please advice. Your help is much appreciated
>
>For more details plz see:
>
>http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=97021

Hi Isfaar,

I see lots of useful (and some less useful) idea posted to that topic
over at sqlteam.com. Did you already try them? Did they help?

--
Hugo Kornelis, SQL Server MVP
My SQL Server blog: http://sqlblog.com/blogs/hugo_kornelis