Query Optimisation as Part of Distribution Design for Complex Value Databases
Hui Ma, Klaus‐Dieter Schewe · 2005
We study the effects of horizontal fragmentation in complex value databases on query processing using a query cost model. We show that optimisation of query processing and optimisation of fragment allocation are largely orthogonal to each other. We then show that if selection predicates used for horizontal fragmentation are ordered according to their likeliness to impact on the query costs, a binary search procedure can be adopted to find an “optimal” fragmentation and allocation.