SQLite Forum

xBestIndex constraints: discern between JOIN and regular constraints
Login
> How can the BestIndex function determine if a given constraint comes from a "result set limiting" constraint or from a "join constraint"?

I'm not sure what those two categories of constraint mean.  SQLite certainly
doesn't make any such distinctions anywhere internally, as far as I know.