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

Indices trade reads for writes (there is no free lunch); if you index every column of your database you'll be able to do any read query reasonably fast but all writes will be slow, if you index nothing then writes will be fast but every read will be a full table scan. Presumably they have their indices because they need them for their read queries.


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

Search: