But why divide 100 and join level ? Is there any reference for this or just a random number?
在 2015年12月3日星期四 UTC+8下午4:10:55，Noel Grandin写道： > > It reduces the cost of a table where we can use lots of index conditions > to access the table. > > This tends to push smaller sets of data towards the first stage of a join, > which reduces the overall cost of a join. > > It's a heuristic, so it's not perfect. > -- 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.
