Thank you for help! It is really different. Is there any way to influence its query plan?
Profile for DBA user:
Error: S1TAT: RC...: Returning incomplete results, query interrupted by result timeout. Activity: 8.896M rnd 8.1M seq 7.432M same seg 1.303M same pg 153.9K same par 25 disk 0 spec disk 0B / 0
{
time 3.8e-06% fanout 1 input 1 rows
Subquery 27
{
time 0.00098% fanout 10000 input 1 rows
RDF_QUAD_POGS 2.6e+07 rows(t3.O$34, t3.G$33, t3.S$32)
inlined P = IRI_ID"...own_who"
time 0.007% fanout 0.8599 input 10000 rows
RDF_QUAD 1 rows(t6.S$39, t6.G$38, t6.O$37)
inlined P = IRI_ID"...name" , S = cast$160
time 0.071% fanout 0.920572 input 8599 rows
Precode:
0: __all_eq$41 := Call __all_eq ( IRI_ID"..." , t6.G$38)
5: BReturn 0
RDF_QUAD 1 rows(t7.S$45, t7.O$44)
inlined P = IRI_ID"...secondname" , S = k_t6.S$176 G = k___all_eq$180
time 0.0036% fanout 1 input 7916 rows
RDF_QUAD 1 rows(t5.S$49, t5.O$48)
inlined P = IRI_ID"...pr" , S = k_t3.O$193
time 0.55% fanout 994.189 input 7916 rows
RDF_QUAD_POGS 24 rows(t14.S$52)
P = IRI_ID"...secondname" , O = k_t7.O$208
time 85% fanout 0.0383053 input 7.87e+06 rows
RDF_QUAD 5.4e-07 rows(t13.S$55)
inlined P = IRI_ID"...name" , S = t14.S$52 , O = k_t6.O$222
time 6.5% fanout 0.999927 input 301463 rows
RDF_QUAD 1 rows(t12.S$59, t12.O$58)
inlined P = IRI_ID"...pr" , S = t13.S$55
time 7.1% fanout 1.28472 input 301441 rows
Precode:
0: __all_eq$61 := Call __all_eq (t3.G$33, IRI_ID"..." )
5: BReturn 0
RDF_QUAD_POGS 1.7 rows(t10.O$65, t10.S$64)
P = IRI_ID"...own_who" , O = cast$247
time 0.12% fanout 0.848265 input 387266 rows
END Node
After test:
0: if (t5.S$49 = t10.O$65) then 5 else 4 unkn 5
4: BReturn 1
5: BReturn 0
time 0.76% fanout 0.613225 input 328504 rows
RDF_QUAD 1 rows(t4.O$68)
inlined P = IRI_ID"...own_what" , S = k_t3.S$275 G = k___all_eq$279
time 0.31% fanout 0.00430386 input 201447 rows
RDF_QUAD_POGS 6.1 rows(t8.S$71)
P = IRI_ID"...aff_legal_entity" , O = cast$291
time 0.0019% fanout 0.472895 input 867 rows
RDF_QUAD 1 rows(t9.O$74)
inlined P = IRI_ID"...aff_organization" , S = t8.S$71
time 0.0015% fanout 0 input 410 rows
RDF_QUAD_POGS 3.6e-08 rows()
inlined P = IRI_ID"...own_what" , O = cast$315 , S = k_t10.S$319
After code:
0: __ro2sq$80 := Call __ro2sq (t5.O$48)
5: _cvt$82 := Call _cvt (<tag 193 flag 0>, __ro2sq$80)
10: __ro2sq$84 := Call __ro2sq (t12.O$58)
15: _cvt$86 := Call _cvt (<tag 193 flag 0>, __ro2sq$84)
20: lt$88 := Call lt (_cvt$82, _cvt$86)
25: if ( 0 = lt$88) then 34 else 29 unkn 34
29: callretSearchedCASE$78 := := artm t5.S$49
33: Jump 38 (level=0)
34: callretSearchedCASE$78 := := artm t10.O$65
38: __ro2sq$92 := Call __ro2sq (t12.O$58)
43: _cvt$94 := Call _cvt (<tag 193 flag 0>, __ro2sq$92)
48: __ro2sq$96 := Call __ro2sq (t5.O$48)
53: _cvt$98 := Call _cvt (<tag 193 flag 0>, __ro2sq$96)
58: lte$100 := Call lte (_cvt$94, _cvt$98)
63: if ( 0 = lte$100) then 72 else 67 unkn 72
67: callretSearchedCASE$90 := := artm t5.S$49
71: Jump 76 (level=0)
72: callretSearchedCASE$90 := := artm t10.O$65
76: BReturn 0
time 0% fanout 0 input 0 rows
Distinct (callretSearchedCASE$90, callretSearchedCASE$78)
time 0% fanout 0 input 0 rows
skip node 1 <none> set_no$30
After code:
0: toUri$28 := := artm callretSearchedCASE$90
4: fromUri$29 := := artm callretSearchedCASE$78
8: BReturn 0
time 0% fanout 0 input 0 rows
Subquery Select(toUri$28, fromUri$29)
}
After code:
0: toUri$118 := Call __ro2sq (toUri$28)
5: fromUri$120 := Call __ro2sq (fromUri$29)
10: BReturn 0
time 0% fanout 0 input 0 rows
Select (toUri$118, fromUri$120)
}
31245 msec 99% cpu, 8.8957e+06 rnd 8.10049e+06 seq 83.5435% same seg 14.6479% same pg
25 disk reads, 0 read ahead, 0.013902% wait
Compilation: 37 msec 0 reads 0% read 0 messages 0% clw
6 Rows. -- 31383 msec.
For sparql user:
LONG VARCHAR
_______________________________________________________________________________
http://sp7.ru/ontology/ei_human_503108557068 http://sp7.ru/ontology/ei_human_feec55030ea4de946983184a55f2889e
{
Precode:
0: <none> := Call DB.DBA.VT_INC_INDEX_DB_DBA_RDF_OBJ ()
7: BReturn 0
END Node
}
0 msec 0% cpu, 2 rnd 0 seq 0% same seg 0% same pg
Compilation: 0 msec 0 reads 0% read 0 messages 0% clw
4 Rows. -- 805 msec.
Stat.dv: