Here's the scenario. We tried to create a full text indexing on a view, unfortunately the view was created based on Left outer join. Hence we were pushed to do the following.
We planned to create a table based on the data that is rendered in this view(this view is formed by combining 14 tables.) . Finally we were able to create a full text indexing on this new table. For simplicity let us called this new table as tableA.
Now the problem is how can we update (if any data is changed on one of the concrete tables of the view) or insert (when new data is inserted in one of the underlying tables of the view) the respective data into this new table - tableA which was created based on this view.
In other words, there should be a sync between the view and tableA. Is it possible to achieve this ???
PS : view is formed based on different tables (not based on tableA)?
The sync should happen whenever that data in the base tables are updated. The data in the view will change accordingly. Whenever the view data changes, then the new data or updated data from the view must be moved to the new table.
Only 1 row of data will be updated in 1 week or 15 datas in a month.
Is this possible to do with the views?
Posted - 07/24/2012 : 01:34:24
