Metadata
Technology & Computer Science Undergraduate Apply Medium
View More
Metadata

  • Subject

    Technology & Computer Science

  • Education level

    Undergraduate

  • Cognitive goals

    Apply

  • Difficulty estimate

    Medium

  • Tags

    indexing, query plan, SQL optimization, EXPLAIN, relational databases

  • Number of questions

    5

  • Created on

  • Generation source

  • License

    CC0 Public domain

  • Prompt

    Assess students' ability to apply indexing strategies and interpret query execution plans to optimize SQL queries in relational databases; tasks include choosing index types (B-tree, hash, composite), predicting index usage, reading EXPLAIN/EXPLAIN ANALYZE outputs (joins, scans, costs, cardinality), identifying bottlenecks (full table scans, poor join order, missing statistics), and proposing concrete rewrites or indexing changes with expected performance impact and justification.
Use
Remix
Export
Review & Revise
Statistics
Remixes
100
Shares
100
Downloads
100
Attempts
100
Average Score
100%

Mock data used for demo purposes.