Hi Army, I love reading your documents! Even if 85% of it is too optimizer-y for me to understand, I learn a lot each time I read through your work. So thanks!
One particular sentence from your most recent writeup stuck out for me, as I had missed this in previous discussions about DERBY-805: The second thing was the fact that I created indexes on T3 and T4 _before_ inserting the data, which (it turns out) leads to outdated (if not altogether incorrect) statistics for the indexes. Are the statistics always incorrect/outdated after inserting lots of data into a table which has one or more indexes? Or was there something specific about the way in which you inserted your data which caused the indexes to have outdated/incorrect statistics? thanks, bryan
