Index a frequently filtered column

SQL Easy 3 views
Back to Questions
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

Solutions (0)

No solutions submitted yet. Be the first!

Discussion (0)

No comments yet. Start the discussion!

Next