📢 Too many exams? Don’t know which one suits you best? Book Your Free Expert 👉 call Now!

  • google app store apple app store
  • âś–

      Question

      Query optimization heuristic that “pushes selections

      down” improves:
      A Join performance Correct Answer Incorrect Answer
      B Sorting efficiency Correct Answer Incorrect Answer
      C Recovery time Correct Answer Incorrect Answer
      D Concurrency Correct Answer Incorrect Answer
      E Index building Correct Answer Incorrect Answer

      Solution

      Applying selections before joins reduces intermediate result size.

      Practice Next
      More IT DBMS Questions
      ask-question