Why is the index range scan cost so higher?
Hi,
I execute a query and i have a good index to use, but the optimizer prefer acces by FTS.
Looking at the 10053 trace, and comparing the cost between FTS and INDEX SCAN: the cost for index is higher than FTS.
The 10053 show the follow:
***************************************
BASE STATISTICAL INFORMATION
***********************
Table stats Table: TTEPRINH Alias: TTEPRINH
TOTAL :: CDN: 12700 NBLKS: 985 AVG_ROW_LEN: 578
-- Index stats
INDEX NAME: CTEPRINH COL#: 1 2
TOTAL :: LVLS: 1 #LB: 68 #DK: 12700 LB/K: 1 DB/K: 1 CLUF: 3557
INDEX NAME: ITEPRIN3 COL#: 2
TOTAL :: LVLS: 1 #LB: 47 #DK: 8 LB/K: 5 DB/K: 183 CLUF: 1465
_OPTIMIZER_PERCENT_PARALLEL = 0
***************************************
SINGLE TABLE ACCESS PATH
Column: COD_OPCTIP Col#: 2 Table: TTEPRINH Alias: TTEPRINH
I execute a query and i have a good index to use, but the optimizer prefer acces by FTS.
Looking at the 10053 trace, and comparing the cost between FTS and INDEX SCAN: the cost for index is higher than FTS.
The 10053 show the follow:
***************************************
BASE STATISTICAL INFORMATION
***********************
Table stats Table: TTEPRINH Alias: TTEPRINH
TOTAL :: CDN: 12700 NBLKS: 985 AVG_ROW_LEN: 578
-- Index stats
INDEX NAME: CTEPRINH COL#: 1 2
TOTAL :: LVLS: 1 #LB: 68 #DK: 12700 LB/K: 1 DB/K: 1 CLUF: 3557
INDEX NAME: ITEPRIN3 COL#: 2
TOTAL :: LVLS: 1 #LB: 47 #DK: 8 LB/K: 5 DB/K: 183 CLUF: 1465
_OPTIMIZER_PERCENT_PARALLEL = 0
***************************************
SINGLE TABLE ACCESS PATH
Column: COD_OPCTIP Col#: 2 Table: TTEPRINH Alias: TTEPRINH
0