Not logged in : Login
(Sponging disallowed)

About: Intelligent Query Optimization     Goto   Sponge   NotDistinct   Permalink

An Entity of Type : http://www.openlinksw.com/ontology/features#Feature, within Data Space : kingsley.idehen.net associated with source document(s)
QRcode icon
http://kingsley.idehen.net/describe/?url=http%3A%2F%2Fdata.openlinksw.com%2Foplweb%2Fproduct_feature%2FIntelligentQueryOptimization%23this

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.

AttributesValues
type
label
  • Intelligent Query Optimization (en)
Description
  • 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.
name
  • Intelligent Query Optimization
hasBenefit
is hasFeature of
Faceted Search & Find service v1.17_git139 as of Feb 29 2024


Alternative Linked Data Documents: PivotViewer | iSPARQL | ODE     Content Formats:   [cxml] [csv]     RDF   [text] [turtle] [ld+json] [rdf+json] [rdf+xml]     ODATA   [atom+xml] [odata+json]     Microdata   [microdata+json] [html]    About   
This material is Open Knowledge   W3C Semantic Web Technology [RDF Data] Valid XHTML + RDFa
OpenLink Virtuoso version 08.03.3330 as of Mar 11 2024, on Linux (x86_64-generic-linux-glibc25), Single-Server Edition (7 GB total memory, 6 GB memory in use)
Data on this page belongs to its respective rights holders.
Virtuoso Faceted Browser Copyright © 2009-2024 OpenLink Software