• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 544
  • Last Modified:

Materialized View Log

Hi,

I have created a materialized log for a table.

T_enterprise_track Table

T_enterprise_track_id, service_id, track_no, status_id, last_accessed_time, activity_id

The column last_accessed_time is updated 30 times a sec. for the new inserted record.

My materialized view contains one column from that table (status_id), which has less updates.

My Materialized view log size will become huge. Since it log unwanted changes

Is there a way to log the fields which selected in the materialized view only not all columns.

Thanks
0
shalsaid
Asked:
shalsaid
1 Solution
 
musduCommented:
Hi,

you're right. You can create a table containing T_enterprise_track_id and status_id columns and update it by using a
row trigger on your table T_enterprise_track. Create a snap-shot of new table instead of T_enterprise_track.

regards.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Improve Your Query Performance Tuning

In this FREE six-day email course, you'll learn from Janis Griffin, Database Performance Evangelist. She'll teach 12 steps that you can use to optimize your queries as much as possible and see measurable results in your work. Get started today!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now