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...
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...