SQL Performance (MOSC)

MOSC Banner

PK index being ignored causing full table scan

edited Jun 3, 2015 10:02AM in SQL Performance (MOSC) 1 commentAnswered

We're running Oracle 11.2.0.3.

Suddenly in last few days some of update queries on one of table not picking up primary key index,

even in where clause we're searching row to be update based on primary key column.

It's performing full table scan.

So far I've done following but no help.

1) gathered stats on table/indexes

2) flushed plan

3) delete stats and gathered stats again

temp. work around:

use Index hint - it avoid full table scan but performing 'Full Scan' on Index instead of 'Unique Scan' !!

Update query is coming from Informatica.

When we perform select/update from sqlplus/other tool, it's using PK index !

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