Yes your are right GSquared,

I did sth stupid,

The test should be:

declare @Runtime table (

Version int,

Runtime int)

declare @Start datetime, @X int

select @start = getdate()

select top 1000 * from b_order

insert into @Runtime...

Odd SSCrazy:

When I do the test with select:

declare @Runtime table (

Version int,

Runtime int)

declare @Start datetime, @X int

select @start = getdate()

select top 100 * from b_order

insert into @Runtime (version, runtime)

select...

Hi Michael,

---These two syntax differences will always generate the same execution plans

I got some idea from the execution plan and I agree with this.

---Once you have outer joins, the...