select * from documents d, reg_value rv where rv.doc = d.id and d.Pin in (2,42,61,82,83)
ðÒÏÃÅÓÓÏÒ ÎÁ ÓÅÒ×ÅÒÅ ÚÁÖÉÒÁÅÔÓÑ ÐÏÌÎÏÓÔØÀ ÎÁ ÐÒÏÔÑÖÅÎÉÉ Ä×ÕÈ ÍÉÎÕÔ, × ÔÅÞÅÎÉÉ ÜÔÉÈ ÖÅ 2 ÍÉÎÕÔ IBEXpert ÏÔÄÙÈÁÅÔ, ÚÁÔÏ ÐÏÔÏÍ ×ÙÄÁÅÔ ÂÏÄÒÏÅ ×ÒÁÎØÅ × ÓÔÒÏÞËÅ "Execute time" ------ Performance info ------ Prepare time = 10ms Execute time = 20ms Avg fetch time = 2,50 ms Current memory = 3 117 056 Max memory = 9 655 296 Memory buffers = 2 048 Reads from disk to cache = 23 403 Writes from cache to disk = 0 Fetches from cache = 9 914 318 îÁ ÚÁÐÒÏÓÅ select * from documents d, reg_value rv where rv.doc = d.id and d.Pin in (2,42,61,82,83) and d.Pin > 0 ×ÓÅ ÒÁÂÏÔÁÅÔ ÐÏ ×ÚÁÐÒÁ×ÄÁÛÎÅÍÕ. (ÎÁ ÓÁÍÏÍ ÄÅÌÅ ÚÁÐÒÏÓÙ ×ÙÐÏÌÎÑÌÉÓØ ÐÏÄÒÑÄ É ÎÁÏÂÏÒÏÔ, ÓÎÁÞÁÌÁ ×ÔÏÒÏÊ, ÐÏÔÏÍ ÐÅÒ×ÙÊ) ------ Performance info ------ Prepare time = 10ms Execute time = 1s 863ms Avg fetch time = 232,88 ms Current memory = 9 654 272 Max memory = 9 655 296 Memory buffers = 2 048 Reads from disk to cache = 28 401 Writes from cache to disk = 0 Fetches from cache = 34 022
