Gaurav Khanna

@gauravkhanna

Free member

I break prod so you do not have to. Python by day, query optimization on weekends.

Indore, Madhya Pradesh10+ years / staff+1 questions6 answers

PythonSnowflakeDatabricksdbt

Streak: 7d
XP: 1900
Lessons done: 14
Studio passes: 12

Week Warrior10 Lessons10 Tickets1,000 XP

Share on X Share on LinkedIn

Questions

votes

answers

views

Query got slower after adding an index, how is that possible

Added an index expecting a speedup on a filtered query, but EXPLAIN ANALYZE shows it actually runs slower than the original sequential scan. status has only 4 distinct values on a 20M row table.

Performanceperformanceindexing