Improving the performance of a query without an index
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!
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!
0