-
Type:
Bug
-
Resolution: Unresolved
-
Priority:
Major - P3
-
None
-
Affects Version/s: None
-
Component/s: None
-
None
-
Query Optimization
-
None
-
None
-
None
-
None
-
None
-
None
-
None
q03: classic order is industry, company, security,
joo picks same order, but uses a HJ at the end, which is more expensive; classic uses ~an INLJ on s_co_id. There's also a CE error.
HJ
| |
| COLLSCAN [security]
|
INLJ (estimated CE: 24.5, actual: 3)
| |
| IXPROBE [company] {co_in_id_idx}
|
COLLSCAN [industry]