SQL Performance (MOSC)

MOSC Banner

Improving the performance of a query without an index

edited May 23, 2013 12:48AM in SQL Performance (MOSC) 11 commentsAnswered
We are on 11.2.0.3
EBS 11.5.10.2

I have a query which is hitting a large table, but for a column which does not have an index. I'm very reticent towards adding indexes onto seeded Oracle Applications tables so I'm investigating any other alternatives.

So really it's just a simple question. Can a query be improved without the use of an index? Note that the column is not part of any other index and the current plan is using a full table scan.

Thanks in advance!

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