Index for joins

SQL Medium 3 views
Back to Questions
Previous Covering index idea Medium P Next When not to index Medium N

Problem Description

Orders joins OrderItems on order_id. Write index statements to support this join.

Input Format

SQL DDL

Output Format

DDL statement(s)

Sample Test Case

Input:
Orders(order_id), OrderItems(order_id)
Output:
Indexes created

Constraints

PK on Orders already indexed
Please login to submit solutions and comments.

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Prev Next