Hi, > Why do you multiply the costs to the level tree nodes?
Because I think that's the right way to do it. Maybe it's wrong. If you have an example where it's wrong and have a better solution then please tell me! > How you choosed the coeficients of item access type (index and so on)? See the source code, specially Optimizer.java, BaseIndex.getCostRangeIndex and so on. > Is there any specific documentation to the cost model? No. > How do you choosed this cost model, have you based in another model? No, I implemented it myself. > Do you have some plan to add other join methods or include CPU cost in the model? No. > Do you use histogram to make some predictions? Currently, histograms are not used, only the index (column) selectivity. Regards, Thomas -- You received this message because you are subscribed to the Google Groups "H2 Database" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/h2-database?hl=en.
