Slide 59
Slide 59 text
【成功例?失敗例?】
クエリーの無駄を Explain で明確にする
load domquery -f "DQL.nsf" -q "Subject = '2019/01/26 13:38:08' and DocNo < 200" -e
0. AND (childct 2) (totals when complete:) Prep 0.0 msecs, Exec 83.430 msecs, ScannedDocs 0, Entries 667, FoundDocs 199
1.Subject = '2019/01/26 13:38:08' View-based equality search estimated cost = 5
Prep 0.412 msecs, Exec 70.818 msecs, ScannedDocs 0, Entries 468, FoundDocs 468
1.DocNo < 200 View-based range search estimated cost = 10
Prep 0.209 msecs, Exec 12.597 msecs, ScannedDocs 0, Entries 199, FoundDocs 199
Total Documents found = 199
load domquery -f "DQL.nsf" -q "DocNo < 200" -e
0.DocNo < 200 View-based range search estimated cost = 10
Prep 0.417 msecs, Exec 13.988 msecs, ScannedDocs 0, Entries 199, FoundDocs 199
Total Documents found = 199