📢 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 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