But 2 result set are same. Why?

Peter Brinkhaus (1/12/2010)

---

You can speed up things a little by doing a 'preselect' on the raw integer values:

SELECT

*

FROM

DateTable

WHERE

DATE1 + 250 > DATE2

...

Sorry, i can't create view, trigger, constrain or every thing except index.

I can't change or add column in this DB because it isn't my DB. No more way to increase performance?

Perfect. Thanks

So sorry, my company don't allow upload file.

<?xml version="1.0" encoding="utf-16"?>

<ShowPlanXML xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xmlns:xsd="http://www.w3.org/2001/XMLSchema" Version="1.1" Build="10.0.1600.22" xmlns="http://schemas.microsoft.com/sqlserver/2004/07/showplan">

<BatchSequence>

<Batch>

<Statements>

...

Why don't use SELF JOIN in this case? Is it simple than outer apply?

SELECT U.FullName,U1.Manager

FROM

@Users U

join @Users U1 on U.Manager=U1.FullName and U1.AccountType = 'Other'

WHERE

U.AccountType = 'Contractor';

I am using Execution Plan and I've got a result:

With 1000000 record and 100000 A distinct value:

- SQL using over (partition): 5%

- SQL using cross apply: 95%

With 1000000 record and...