Add an index via DDL

SQL Medium 2 views
Back to Questions
Previous Create table with timestamps Easy P Next Add a foreign key after table creation Medium N

Problem Description

Create an index on Orders(order_date) to speed up date range filters.

Input Format

SQL DDL

Output Format

DDL statement(s)

Sample Test Case

Input:
Orders(order_id, order_date)
Output:
Index created

Constraints

Assume Orders exists
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