InterviewSolution
Saved Bookmarks
InterviewSolution
| 1. |
Why Union All Faster Than Union? |
|
Answer» The UNION OPERATION REMOVES redundancy while UNION ALL does not; therefore, the UNION operation NEEDS to perform sort. As a RESULT, UNION ALL performs BETTER as it does not need to perform any sort. The UNION operation removes redundancy while UNION ALL does not; therefore, the UNION operation needs to perform sort. As a result, UNION ALL performs better as it does not need to perform any sort. |
|