Hi Maria, Basic details on understanding query plans can be found at:
http://docs.openlinksw.com/virtuoso/databaseadmsrv.html#perfdiagqueryplans
Is there a specific problem you have having with the query ?
Best Regards
Hugh Williams
Professional Services
OpenLink Software, Inc. // http://www.openlinksw.com/
Weblog -- http://www.openlinksw.com/blogs/
LinkedIn -- http://www.linkedin.com/company/openlink-software/
Twitter -- http://twitter.com/OpenLink
Google+ -- http://plus.google.com/100570109519069333827/
Facebook -- http://www.facebook.com/OpenLinkSoftware
Universal Data Access, Integration, and Management Technology Providers
> On 28 Jan 2016, at 16:49, Maria Jackson <[email protected]> wrote:
>
> Dear All,
>
> I ran the following query on Virtuoso:
> select ?a?b?c?h?f?fnco ((?f+1001) * (?fnco+1) as ?ero) where{ graph ?g{?a
> <pred2> ?f} graph ?g1{?a <pred1> ?b} graph ?g2{?b <pred3> ?c} graph ?g3{?c
> <pred4> ?h} graph ?g4{?g3 <pred5> ?fnco}} order by asc(?ero) limit 50
>
> The above query generated the following plan. If possible, can someone please
> help me in understanding the generated plan:
>
> Connected to OpenLink Virtuoso
> Driver: 07.20.3215 OpenLink Virtuoso ODBC Driver
> OpenLink Interactive SQL (Virtuoso), version 0.9849b.
> Type HELP; for help and EXIT; to exit.
> SQL> SQL> REPORT
> VARCHAR
> _______________________________________________________________________________
>
> {
> Subquery 27
> {
> { fork
> RDF_QUAD 8.7e+04 rows(s_1_3_t1.S, s_1_3_t1.O)
> inlined P = #/pred1
> RDF_QUAD 1 rows(s_1_1_t0.O)
> inlined P = #/pred2 , S = s_1_3_t1.S
>
> Precode:
> 0: temp := artm s_1_1_t0.O + 1001
> 4: BReturn 0
> RDF_QUAD 1.8 rows(s_1_5_t2.O, s_1_5_t2.S)
> inlined P = #/pred3 , S = k_s_1_3_t1.O
> RDF_QUAD 1.1 rows(s_1_7_t3.G, s_1_7_t3.S, s_1_7_t3.O)
> inlined P = #/pred4 , S = cast
> RDF_QUAD 1 rows(s_1_9_t4.O)
> inlined P = #/pred5 , S = s_1_7_t3.G
>
> After code:
> 0: temp := artm s_1_9_t4.O + 1
> 4: temp := artm temp * temp
> 8: BReturn 0
> Sort (temp) -> (s_1_3_t1.S, s_1_5_t2.S, s_1_7_t3.S, s_1_7_t3.O, s_1_1_t0.O,
> s_1_9_t4.O)
>
> }
> top order by read (s_1_3_t1.S, s_1_5_t2.S, s_1_7_t3.S, s_1_7_t3.O,
> s_1_1_t0.O, s_1_9_t4.O, temp)
>
> After code:
> 0: __ro2sq := Call __ro2sq (s_1_9_t4.O)
> 5: __ro2sq := Call __ro2sq (s_1_1_t0.O)
> 10: __ro2sq := Call __ro2sq (s_1_7_t3.O)
> 15: __id2in := Call __id2in (s_1_7_t3.S)
> 20: __id2in := Call __id2in (s_1_5_t2.S)
> 25: __id2in := Call __id2in (s_1_3_t1.S)
> 30: a := := artm __id2in
> 34: b := := artm __id2in
> 38: c := := artm __id2in
> 42: h := := artm __ro2sq
> 46: f := := artm __ro2sq
> 50: fnco := := artm __ro2sq
> 54: ero := := artm temp
> 58: BReturn 0
> Subquery Select(a, b, c, h, f, fnco, ero)
> }
>
> After code:
> 0: a := Call __ro2sq (a)
> 5: b := Call __ro2sq (b)
> 10: c := Call __ro2sq (c)
> 15: h := Call __ro2sq (h)
> 20: f := Call __ro2sq (f)
> 25: fnco := Call __ro2sq (fnco)
> 30: ero := Call __ro2sq (ero)
> 35: BReturn 0
> Select (a, b, c, h, f, fnco, ero)
> }
>
> 57 Rows. -- 5 msec.
>
> ------------------------------------------------------------------------------
> Site24x7 APM Insight: Get Deep Visibility into Application Performance
> APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month
> Monitor end-to-end web transactions and take corrective actions now
> Troubleshoot faster and improve end-user experience. Signup Now!
> http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140_______________________________________________
> Virtuoso-users mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/virtuoso-users
smime.p7s
Description: S/MIME cryptographic signature
------------------------------------------------------------------------------ Site24x7 APM Insight: Get Deep Visibility into Application Performance APM + Mobile APM + RUM: Monitor 3 App instances at just $35/Month Monitor end-to-end web transactions and take corrective actions now Troubleshoot faster and improve end-user experience. Signup Now! http://pubads.g.doubleclick.net/gampad/clk?id=267308311&iu=/4140
_______________________________________________ Virtuoso-users mailing list [email protected] https://lists.sourceforge.net/lists/listinfo/virtuoso-users
