FK Flashcards
FK
1
Q
Select *
A
Hash Join
2
Q
Select Distinct *
A
Hash Unique
3
Q
from t1, t2
A
Table Access Full, Table Access Full
4
Q
Use_Hash or No_Index
A
n/a
5
Q
Use_Merge
A
Merge Join, Sort Join, Sort Join
6
Q
Index
A
Table Access By Index ROWID, Index Full Scan
7
Q
Use_NL
A
Nested Loops
8
Q
Group By and Order By
A
Sort Group By
9
Q
Group By
A
Hash Group By
10
Q
Order By
A
Sort Order By
11
Q
Distinct & Order By
A
Sort Unique
12
Q
Hash Aggregation and Order By
A
n/a
13
Q
Group By Cube
A
Sort Group By, Generate Cube, Sort Group By
14
Q
Group By Rollup
A
Sort Group By Rollup
15
Q
Cumulative Aggregate
A
Windows NoSort, Sort Group By
