Re: [sqlite] vtab stat*

On 8/6/18, Giorgi Guliashvili wrote: > I'm wondering if > SQLITE_ENABLE_STAT4 works for vtabs and what are the other options I have. No. STAT4 provides information about indexes. But virtual table have no indexes - at least not indexes visible to the rest of the system. (A specific virtual

[sqlite] vtab stat*

Hi folks, I'm using only Eponymous virtual tables, however, so far, the only hint I give to the query planner was through some heuristic computing xBestIndex->estimatedCost. Now I'm considering other automatic, updating weights. I'm wondering if SQLITE_ENABLE_STAT4 works for vtabs and what are