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

6363
Ramesh_R wrote:
Hi all,
I have a secenario like to check the old values and new values of a record inside a trigger
like :new.col_name = :old.col_name. The scenario is i need to dynamically iterate thro' all
the column values. because the number of columns is large and keeps on changing in future too.
Can't do that.

Simply add your trigger code to the same source repository as you table creation scripts, and when the table is updated, update and deploy the trigger too.
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,734 views