Never seen this before.
I have a query, where I am join it back onto itself with a different subset each time using a where
So
Select
*
From
(select * from t
Where x
Inner join
(select * from t
Where y
)
On conditions
Etc
4 join. Conditions present
Adding top 100 pc to each sub query speeds the query up many times over.
It makes no sense to me.
Any ideas?
I have a query, where I am join it back onto itself with a different subset each time using a where
So
Select
*
From
(select * from t
Where x
Inner join
(select * from t
Where y
)
On conditions
Etc
4 join. Conditions present
Adding top 100 pc to each sub query speeds the query up many times over.
It makes no sense to me.
Any ideas?