Rebuild index after heavy deletes

SQL Hard 5 views
Back to Questions
Previous Avoid duplicate indexes Hard P Next Functional index for case-insensitive search Hard N

Problem Description

After deleting millions of rows, you want to rebuild an index. Provide a generic rebuild statement.

Input Format

SQL DDL

Output Format

DDL statement(s)

Sample Test Case

Input:
Index exists
Output:
Index rebuilt

Constraints

Syntax varies by DB
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