PLAN JOIN (N_SESSION NATURAL, N_DATA INDEX (FK_BAGUE_ID_SESSION))
Query Time
------------------------------------------------
Prepare : 0.00 ms
Execute : 6*973.00 ms
Avg fetch time: 217.91 ms
Memory
------------------------------------------------
Current: 105*849*392
Max : 134*151*456
Buffers: 2*048
Operations
------------------------------------------------
Read : 104*905
Writes : 0
Fetches: 11*435*963
Marks : 0
Enchanced Info:
+--------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
| Table Name | Records | Indexed | Non-Indexed | Updates | Deletes | Inserts | Backouts | Purges | Expunges |
| | Total | reads | reads | | | | | | |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
| N_DATA| 0 | 4481039 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| N_SESSION| 0 | 0 | 493370 | 0 | 0 | 0 | 0 | 0 | 0 |
+--------------------------+-----------+-----------+-------------+---------+---------+---------+----------+----------+----------+
Partager