Hi Matjaz

The query executes at a similar execution time: 15:55

Guys heres the function:

CREATE FUNCTION CallSearchL3_2 (@intInstanceID int,@intCustomerID int, @bitShowPersonal bit, @structure int)

RETURNS TABLE AS

RETURN

(

SELECT

dbo.Call.intCallID, dbo.Member.vchrMember,

dbo.Call.vchrConvertedDialledDigits,

ISNULL(vab.vchrName + ' (' + vab.vchrDestination + ')',

dbo.Call.vchrDialledLocation)...

Hi PW

You're correct defraging does occur every weekend so fragmentation has improved.

I'm still curious about the number of executions and locks is that because of the function use?...

Here are some results from the suggestions, apologies now for the length of the post.

I have run both a trace and execution plan on the same query.

Execution Time 1:43

Trace Results:

SELECT...

PW, I will look at what you have suggested.

Jeff, I should have tried to make it clearer, once the query execution time starts to take 10x longer than usual it...

Hi

Just to add the query is generated from a web application which runs a reporting wizard so the statement below was captured using SQL Profiler.

Here is the query:

SELECT count(*) as...