Find unused indexes (query)

SQL Hard 4 views
Back to Questions
Previous Partial index workaround using helper column Medium P Next Design index for prefix search Hard N

Problem Description

Write a query idea to list indexes that are not used often. Keep it simple and generic.

Input Format

SQL query

Output Format

Result set

Sample Test Case

Input:
DB metadata tables
Output:
Index list

Constraints

DB-specific; show a general metadata read
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