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) I understand that ANALYZE is used to gather statistics about the available indices and helps the query optimizer. So if if I've never ran the analyze... what statistics the optmizer will use? If I never run ANALYZE the statistics will never be updated? Thanks! _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users