Uploaded image for project: 'Blazegraph (by SYSTAP)'
  1. Blazegraph (by SYSTAP)
  2. BLZG-1795

badly incorrect estimated cardinalities with VALUES

    XMLWordPrintable

    Details

      Description

      The construct:

       { ?ClinicalTrial_A sys:assignedProject ?_xProject15. # ACCESS CONTROL
              VALUES (?_xProject15) {
                  ( </bdm/api/project/13> )
                  ( </bdm/api/project/14> )
                  ( </bdm/api/project/15> )
                  ( </bdm/api/project/16> )
                  ( </bdm/api/project/17> )
              } }
      

      is getting an estimated cardianlity of 9,438 when the actual value is 31,763,541.
      Since this is a basic construct in many of our queries, I am concerned that we are having at least some queries being badly optimized.

        Attachments

          Activity

            People

            Assignee:
            michaelschmidt michaelschmidt
            Reporter:
            jjc Jeremy Carroll
            Votes:
            0 Vote for this issue
            Watchers:
            4 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: