Zapytania wykonywałem w EMS SQL Manager for InterBase and Firebird
To samo zapytanie wykonane po raz
pierwszy:
Query Performance
Prepare : 0 ms
Execute : 0 ms
Avg fetch time: 0 ms
Memory Usage
Current: 910,57 kB
Max : 914,43 kB
Buffers: 75
Database Operations
Reads : 5809
Writes : 5420
Fetches: 57682
Plan:
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (T NATURAL, CEX INDEX (RDB$PRIMARY7)), C INDEX (RDB$PRIMARY3)), RG INDEX (KRABATGRUPA)), K INDEX (RDB$PRIMARY6)), P INDEX (RDB$PRIMARY2)), GT INDEX (RDB$PRIMARY1)), N INDEX (RDB$PRIMARY8)), H INDEX (INDEX_NAMD5))
Table Operations:
Table Name | Index reads | Non-Index reads | Updates | Deletes | Inserts
TABLE1 | 0 | 59 | 0 | 0 | 0
TABLE2 | 59 | 0 | 0 | 0 | 0
TABLE3 | 59 | 0 | 0 | 0 | 0
TABLE4 | 59 | 0 | 0 | 0 | 0
TABLE5 | 59 | 0 | 0 | 0 | 0
drugi:
Query Performance
Prepare : 0 ms
Execute : 0 ms
Avg fetch time: 0 ms
Memory Usage
Current: 898,34 kB
Max : 915,26 kB
Buffers: 75
Database Operations
Reads : 31
Writes : 31
Fetches: 1646
Plan:
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (T NATURAL, CEX INDEX (RDB$PRIMARY7)), C INDEX (RDB$PRIMARY3)), RG INDEX (KRABATGRUPA)), K INDEX (RDB$PRIMARY6)), P INDEX (RDB$PRIMARY2)), GT INDEX (RDB$PRIMARY1)), N INDEX (RDB$PRIMARY8)), H INDEX (INDEX_NAMD5))
Table Operations:
Table Name | Index reads | Non-Index reads | Updates | Deletes | Inserts
TABLE1 | 0 | 57 | 0 | 0 | 0
TABLE2 | 57 | 0 | 0 | 0 | 0
TABLE3 | 57 | 0 | 0 | 0 | 0
TABLE4 | 57 | 0 | 0 | 0 | 0
TABLE5 | 57 | 0 | 0 | 0 | 0
trzeci:
Query Performance
Prepare : 0 ms
Execute : 0 ms
Avg fetch time: 0 ms
Memory Usage
Current: 898,34 kB
Max : 915,26 kB
Buffers: 75
Database Operations
Reads : 0
Writes : 0
Fetches: 1646
Plan:
PLAN JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (JOIN (T NATURAL, CEX INDEX (RDB$PRIMARY7)), C INDEX (RDB$PRIMARY3)), RG INDEX (KRABATGRUPA)), K INDEX (RDB$PRIMARY6)), P INDEX (RDB$PRIMARY2)), GT INDEX (RDB$PRIMARY1)), N INDEX (RDB$PRIMARY8)), H INDEX (INDEX_NAMD5))
Table Operations:
Table Name | Index reads | Non-Index reads | Updates | Deletes | Inserts
TABLE1 | 0 | 57 | 0 | 0 | 0
TABLE2 | 57 | 0 | 0 | 0 | 0
TABLE3 | 57 | 0 | 0 | 0 | 0
TABLE4 | 57 | 0 | 0 | 0 | 0
TABLE5 | 57 | 0 | 0 | 0 | 0