Virtuoso Wiki Web

  • Topic
  • Discussion
    • VirtuosoWikiWeb.DebuggingPoorSQLQueryPerformance(Last) -- Owiki? , 2016-08-19 15:01:34 Edit
    [TXT]
    [PLAIN]
    [DOCBOOK]
    owiki 2016-08-19 15:01:34

    Poor Performance

    Debugging Poor SQL Query Performance

    Are you encountering poor performance issues with Virtuoso SQL queries? If so, use the explain function to troubleshoot this problem. The explain function compiles individual SQL statements and returns a description of the compilation. The description contains insight into join order, sub-query structure, and order of evaluation of predicates, and the splitting of distributed VDB queries across different data sources. This information is valuable to the detection of performance bottlenecks. Visit the following page for more information on use of explain:

    http://docs.openlinksw.com/virtuoso/fn_explain.html

    If you require assistance from OpenLink Product Support, be sure to provide explain output along with the original query, a Virtuoso server version string, and statement of whether or not you are using the Open Source or commercial edition.