PK Flashcards
PK
1
Q
Select *
A
Merge Join, Sort Join/Buffer Sort
2
Q
Select Distinct
A
n/a
3
Q
From t1, t2
A
Table Access By Index ROWID, Index Full Scan
4
Q
Use_Hash or No_Index
A
Force Hash Join
5
Q
Index
A
n/a
6
Q
Use_NL
A
Nested Loops
7
Q
Group by Order By
A
Sort Group By
8
Q
Order By
A
n/a
9
Q
Group By
A
Hash Group By
10
Q
Distinct and order by
A
n/a
11
Q
Hash_Aggregation and order by
A
Force Sort Order By
12
Q
Group By Cube
A
Sort Group By, Generate Cube, Sort Group By
13
Q
Group By Rollup
A
Sort Group By Rollup
14
Q
Cumulative Aggregate
A
Windows NoSort, Sort Group By
15
Q
Moving Aggregate
A
Windows Buffer, Sort Group By
