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

    Question

    Query optimization heuristics often

    include:
    A Push selections early Correct Answer Incorrect Answer
    B Join smaller tables first Correct Answer Incorrect Answer
    C Replace cartesian products with joins Correct Answer Incorrect Answer
    D Use indexes where possible Correct Answer Incorrect Answer
    E All of the above Correct Answer Incorrect Answer

    Solution

    All are heuristics used before cost-based optimization to reduce intermediate result size.

    Practice Next
    More IT DBMS Questions
    ask-question