I'm working with 2 of the same datasets. However, one is derived from a temp table and the other is from a derived table (
cross apply operator). The derived table takes much longer to process and it is a simple query. I've been told to avoid apply operator because they use row by row processing.
- Does the
applyoperator use row by row processing?
- Should I limit my use of
applyoperators like cursors and trigger statements? (Only use in specific situations)