Tag Info

New answers tagged


Can anyone tell how exactly apply works and how will it effect the performance in very large data APPLY is a correlated join (called a LATERAL JOIN in some products and newer versions of the SQL Standard). Like any logical construction, it has no direct impact on performance. In principle, we should be able to write a query using any logically ...


The first query may run parallel by only one request to sql server. It fetched the all record and gives output based on filter criteria. But in case of second one it runs row by row and for each row Table2 will be scanned and appended to result. if your outer query has less record then Second one is better(OUTER APPLY). But if first query may get more data ...

Top 50 recent answers are included