How to avoid - TABLE ACCESS BY INDEX ROWID
First of all, I'm not sure if I need to avoid TABLE ACCESS BY INDEX ROWID. Our internal team wants us to avoid TABLE ACCESS BY INDEX ROWID, and would like to contain everything within the index.
Let me start with this question : Is TABLE ACCESS BY INDEX ROWID bad ? If socan someone say what are the issues ?
Table: We have a table with 15million rows.
I've the following query which performs "TABLE ACCESS BY INDEX ROWID"
SELECT COUNT (*)
FROM
(SELECT
*
FROM TERRITORY_DN_V amgen3
WHERE (amgen3.TERR_DIMENSION_CODE = 'Geo'
AND ( ((amgen3.TERR_DIM_NODE_INTG_ID = '300000000149103')