Not logged in : Login |
Virtuoso has a cost based optimizer that uses statistics for deciding join order, join type, index usage, and other execution plan matters. Virtuoso supports hash and loop joins, reusing hash join hash tables if the underlying data does not change, and merge intersection of indices for multiple index lookup. The optimizer automatically recognizes loop invariants and calculates these as early as possible. A special explain function allows viewing the execution plan. Optimizer directives exist for direct control of join order, join type, and index usage.
Attributes | Values |
---|---|
type | |
label |
|
Description |
|
name |
|
hasBenefit |