issues: 1097091527

This data as json

id node_id number title user state locked assignee milestone comments created_at updated_at closed_at author_association pull_request body repo type active_lock_reason performed_via_github_app reactions draft state_reason
1097091527 I_kwDOCGYnMM5BZEnH 369 Research how much of a difference analyze / sqlite_stat1 makes 9599 closed 0     11 2022-01-09T03:03:36Z 2022-02-03T21:07:41Z 2022-02-03T21:07:35Z OWNER  

Is there a downside to having a sqlite_stat1 table if it has wildly incorrect statistics in it?

Originally posted by @simonw in https://github.com/simonw/sqlite-utils/issues/365#issuecomment-1008163050

More generally: how much of a difference does the sqlite_stat1 table created by ANALYZE make to queries?

I'm particularly interested in group by / count * queries since Datasette uses those for faceting.

 140912432 issue     
{
    "url": "https://api.github.com/repos/simonw/sqlite-utils/issues/369/reactions",
    "total_count": 0,
    "+1": 0,
    "-1": 0,
    "laugh": 0,
    "hooray": 0,
    "confused": 0,
    "heart": 0,
    "rocket": 0,
    "eyes": 0
}
   completed

Links from other tables