SQL Index Advisor

Input Workload

Table Schema (DDL)

SQL Query (Workload) 1 Query

Separate multiple queries with a semicolon (;)

Seq Scan

Current Path

~45x

With Recommendations

Seq Scan on table

Filter: ...

➡

Index Scan using idx

Index Cond: ...

Estimated Records: 1,000,000

Index Type Comparison:

B-Tree (~45MB)

Hash (~30MB)

GIN (~60MB)

Estimations based on data types and cardinalities.