Last week in QOT: Index/Predicate Selectivity Analysis
May 25th, 2009 at 8:21am |
Last weekend I’ve reached a milestone in my work on the statistical index analysis for QOT. The code is available on Launchpad.
An example is worth a thousand words, so I start with one (once again I’m using employees-db):
$ ./qot –info –host=192.168.200.1 –analyse=possible –schema=employees –query=”select * from dept_emp where (dept_no = ‘d005′ or dept_no = ‘d006′) […]
Read the rest of Last week in QOT: Index/Predicate Selectivity Analysis