Indeed! An index can be the difference between a 2-5minute full table scan and a... | Hacker News

Hacker Newsnew | past | comments | ask | show | jobs | submit

		voiper1 on June 20, 2016 \| parent \| context \| favorite \| on: We’re pretty happy with SQLite and not urgently in... Indeed! An index can be the difference between a 2-5minute full table scan and a subsecond query.

Sami_Lehtinen on June 20, 2016 [–]

Depends from your disk system and data set size ... It can also mean 2-5 hours or days versus subsecond query. Try having 6 TB database with integer column. Then select just one row from it. Either it's indexed or not. You don't need to explain that, if query ends up taking forever it wasn't indexed.

Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact