engineering computer science MCQ #794

Which query optimization technique involves reordering joins?

engineering computer science MCQ #794

  1. Question 1

    Q1. Which query optimization technique involves reordering joins?

    • A) Indexing
    • B) Caching
    • C) Join reordering
    • D) Query rewriting

    Answer: Join reordering

    Explanation: Join reordering optimizes queries by reordering joins to reduce the number of records being joined.