Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
10.4(EOL), 10.5
Description
For non-indexed columns ranges are created when optimizer_use_condition_selectivity > 2 and with the help of EITS we are able to make estimates for predicates which involved non-indexed columns.
Eg:
SELECT * FROM t1 WHERE a = 10; |
If there is no index on column a we will create a range for a=10 and get the statistics from EITS. It would be good to print this range in the optimizer trace too.
We already print ranges for indexed columns in the optimizer trace.
Attachments
Activity
Transition | Time In Source Status | Execution Times |
---|
|
4d 2h 10m | 1 |
|
4h 45m | 1 |
|
21d 23h 25m | 1 |
|
1d 15h 17m | 1 |