Index a frequently filtered column

SQL Easy 4 views
Back to Questions
Previous No previous question
Next Composite index for search Easy N

Problem Description

Orders table is filtered by status a lot. Create an index on status.

Input Format

SQL DDL

Output Format

DDL statement(s)

Sample Test Case

Input:
Orders(status)
Output:
Index created

Constraints

None
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