The main purpose of my question was to try to find way of indexed view implementation using underlying tables that resides on another server. This view will not use aggregations...

Thanks for your answer lakusha.

Please, will you explain me why do you think that SQL Server indexed view will have more overheads than (for example) stored procedure that retrieves...

Hi Rajiv

Thanks for your code. I think that you misunderstand me!

The problem is not how to insert row. As you can see I already created function fnWord that extract words...

Sorry for wrong information!  My mind was somewhere else when I wrote info. OS 'Windows NT 5.0 (Build 2195: Service Pack...