When not to index

SQL Medium 2 views
Back to Questions
Previous Index for joins Medium P Next Partial index workaround using helper column Medium N

Problem Description

You have a column gender with only 2 values. Should you index it? Provide a practical answer in description, and give no index statement.

Input Format

SQL DDL

Output Format

DDL statement(s)

Sample Test Case

Input:
Employees(gender)
Output:
No index created

Constraints

Low cardinality columns often do not benefit
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