100 likes | 186 Views
Select. Full table access Emp. C tot =37. Id=0. C=37. Id=1. Query 1 e 2. Select. Fast full scan index. C tot =11. Id=0. C=11. Id=1. Query 3. Select. Merge join. Full table access Emp. By index row id Dept. Full scan index Dept. Sort Emp. Id=0. C=679. Id=1. C=3. Id=2. C=1.
E N D
Select Full table access Emp Ctot=37 Id=0 C=37 Id=1 Query 1 e 2
Select Fast full scan index Ctot=11 Id=0 C=11 Id=1 Query 3
Select Merge join Full table access Emp By index row id Dept Full scan index Dept Sort Emp Id=0 C=679 Id=1 C=3 Id=2 C=1 C=37 Id=5 C=676 Id=4 C=679 Id=3 Tabella Dept Tabella Emp Query 4
Select Merge join Full table access Emp Sort Salgrade Full table access Salgr Sort Emp Id=0 C=134 Id=1 C=5 Id=2 C=2 C=37 Id=5 C=130 Id=4 C=134 Id=3 Tabella Salgrade Tabella Emp Query 5
Select Merge join Full table access Emp By index row id Dept Full scan index Dept Sort Emp Id=0 C=82 Id=1 C=3 Id=2 C=1 C=37 Id=5 C=79 Id=4 C=82 Id=3 Tabella Dept Tabella Emp Query 6
Select By index row id Emp Range scan index Emp Ctot=66 Id=0 C=66 Id=1 C=15 Id=2 Query 7
Select Sort Nested loop Full table access Emp Unique scan index Dept Id=1 C=112 Id=0 C=37 Id=2 Id=4 C=37 Id=3 C=112 C=0 Tabella Emp Tabella Dept Query 8
Select Merge join Nested loop Sort Salgrade Full table access Salgr Unique scan index Dept Full table access Emp By index row id Dept Sort Emp C=5 C=37 C=2 Id=3 Id=4 C=0 Id=0 C=334 Id=2 Id=8 C=335 Id=7 C=335 Id=1 C=1 Id=5 Id=6 C=330 Tabella Dept Tabella Salgrade Tabella Emp Query 9
Select Hash join Full table access Dept Full table access Emp Tabella Dept Tabella Emp C=40 Id=0 C=40 Id=1 C=2 Id=2 C=37 Id=3 Query 10
Select Hash join Full table access Salgr Full table access Emp Tabella Salgrade Tabella Emp C=40 Id=0 C=40 Id=1 C=2 Id=2 C=37 Id=3 Query 11