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

> and presumably other things?

Various statistical views over the value distributions of the indexes, so that the planner can estimate how useful (selective) the index should be.

sqlite_stat1 just gives an average (number of records in the index, and average number of records per value), and if enabled sqlite_stat4 stores histogram data.

 help



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

Search: