Skip to content
Advertisement

how to Optimize SQL query cross apply

How to optimize this SQL statement. I have tried to put code written in cross apply in another function and in select.

Advertisement

Answer

As written, I would recommend an index on:

That said, it might be possible to rewrite the query so it is more efficient. However, this question does not provide enough information to make suggestions.

User contributions licensed under: CC BY-SA
10 People found this is helpful
Advertisement