[sqlite] Sqlite3_step

Hi, since sqlite does a nested loop to evaluate queries, is it possible to know how many interactions have each loop, i.e. how many rows in the table that loop will interact, and which table is that? And how can I use the WHERETRACE function that prints the optimization steps? Thanks! --

Re: [sqlite] Help me understand the sqlite query optimizer

Thanks for the big and helpful explanation Simon! My changes in my study, theoretically, would improve the performance just of big and complex queries, so it's not my intention improve the sqlite, I want just study the effects.. Just a few more questions if anyone can help me 1) So if I run

[sqlite] Help me understand the sqlite query optimizer

Hi!! I'll implement some changes in the sqlite query optimization for study purpose... before I start studying the code please help me understand the basic idea... 1) The basic idea of optimization is to optmize and then execute. Where in the code the plan is built and where it is executed? 2)