Replacement of CROSS APPLY statement
Home > IT Answers > SQL Server > Replacement of CROSS APPLY statement
Archanaraghulohe
10 pts.
0
Q:
Replacement of CROSS APPLY statement
SQL Server 2005 connectivity, CROSS APPLY statement, SQL Server 2005
1. I am running query in which cross apply operator is used
2. That same query exceutes more than 10 times
3. Due to cross apply it increase the time to excute the report
ASKED: Jun 15 2009  8:12 AM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Emtucifor
50 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Background Information:

The CROSS APPLY does a Cartesian join between the tables. Depending on what's being joined, this can cause the run time of the query to increase as SQL is taking the number of rows in the first table times the number or rows in the second.

CROSS APPLY can solve some problems that would be very difficult to solve other ways, but it is often not the best answer. In some cases, it IS the best answer (I’ve used it with a linked server query in a way that resulted in hundreds of times performance improvement).

Answer

Are you sure that the CROSS APPLY is the correct thing to do? What result are you trying to get?

Please post the query you are using. If CROSS APPLY is using a function, please post the function declaration.

It would also probably be useful to have the DDL for the tables involved, and possibly the indexes, too. Right-click on the table and script to the clipboard.

With more information we can provide you with a better answer.
Last Answered: Jul 8 2009  7:06 PM GMT by Emtucifor   50 pts.
Latest Contributors: Mrdenny   46795 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Emtucifor   50 pts.  |   Jul 8 2009  7:03PM GMT

Please post the query you are using. If CROSS APPLY is using a function, please post the function declaration.

It would also probably be useful to have the DDL for the tables involved, and possibly the indexes, too. Right-click on the table and script to the clipboard.

CROSS APPLY can solve some problems that would be very difficult to solve other ways, but it is often not the best answer. In some cases, it IS the best answer (I’ve used it with a linked server query in a way that resulted in hundreds of times performance improvement).

 

Emtucifor   50 pts.  |   Jul 8 2009  7:06PM GMT

Clearly I didn’t know how to use this site. Please ignore my discussion comment I posted.

 
0