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

Reply via email to