In TableFilter.getBestPlanItem() after calculating the cost the this item, I see this:
// The more index conditions, the earlier the table. // This is to ensure joins without indexes run quickly: // x (x.a=10); y (x.b=y.b) - see issue 113 item.cost -= item.cost * indexConditions.size() / 100 / level; it seems a bit confused to me, what is earlier mean? Why make joins run quickly without indexes? Can somebody explain further? -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/h2-database. For more options, visit https://groups.google.com/d/optout.
