Skip to Main Content
Forums

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

Comments

Answer

Reproduced, bugged, thank you.

Marked as Answer by Graeme Douglas · Mar 18 2022
1 - 1
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Jan 20 2016
Added on Dec 22 2015
#general-database-discussions, #index, #performance
15 comments
2,730 views