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


    ⚡ Month End Offer - Flat 52% Off On All Courses! Enroll Now ⚡
    00:00:00 AM Left

    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
    ask-question