SQL Performance (MOSC)

MOSC Banner

How to avoid - TABLE ACCESS BY INDEX ROWID

edited Feb 4, 2015 3:27AM in SQL Performance (MOSC) 9 commentsAnswered

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')

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center