Add an index via DDL
Medium
SQL
DDL
12 views
Problem Statement
Create an index on Orders(order_date) to speed up date range filters.
Input Format
SQL DDL
Output Format
DDL statement(s)
Example
Orders(order_id, order_date)
Index created
Constraints
Assume Orders exists
Input / Output Format
Input Format
SQL DDL
Output Format
DDL statement(s)
Constraints
Assume Orders exists
Examples
Input:
Orders(order_id, order_date)
Output:
Index created
Example Solution (Public)
CREATE INDEX idx_orders_order_date ON Orders(order_date);
Official Solution Code
CREATE INDEX idx_orders_order_date ON Orders(order_date);
Please login to submit solutions.