Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Performance issue - Oracle Index not working

VK-Ora-newbee-OracleDec 22 2015 — edited Dec 23 2015

Hi Gurus,

I'm facing performance issue in my application. we are having two trans tables and each tables having more than Millions of records.

From application layer we are fetching data this tables for summary screen. In that screen we are using default filters. after that filter we are getting nearly 40% of data.

So the indexing is not working. please give your suggestions .

@Thanks Advance

-VK

Locked Post

New comments cannot be posted to this locked post.

Locked on Jan 20 2016

Added on Dec 22 2015

#general-database-discussions, #index, #performance

15 comments

2,731 views