What is the setting of OPTIMIZER_INDEX_COST_ADJ in your init.ora file?
You should set this parameter to a low value (maybe 10).
Try it with your query:
Code:ALTER SESSION SET OPTIMIZER_INDEX_COST_ADJ = 10; SELECT * FROM BUILDING_INFO WHERE BLD_SEQ_ID=21261023;![]()




Reply With Quote