Query optimization with zone map selectivity modeling

作者: Garth A. Dickie , Jay B. Wolf

DOI:

关键词: Product (mathematics)Query optimizationDatabaseComputer programDegree (graph theory)Data miningValue (computer science)Computer scienceRange (statistics)Query planElement (category theory)

摘要: According to one embodiment of the present invention, a system for processes query accessing data within or more database objects stores an element object among plurality different storage regions. Each region is associated with first and second range values indicating value that region. The examines regions each determines effectiveness representing degree overlap between element. selectivity model utilizing value, plan based on model, executes plan. Embodiments invention further include method computer program product processing in substantially same manners.