Running query against multiple instances

We have production databases/instances (all having same schema) running on multiple different platforms across the country. I would like to be able to enter a query (from any of them) and have it run against all of them.

My only idea so far has been to create a view which is something like

create view globalemp as select * from emp_at_east union select * from emp_at_west ...

and execute the query against that. this works but seems inefficient. plus each time we add or subtract a platform all views thus constructed need to be recompiled.

Does anyone have any other suggestions? Can I somehow dynamically build a list of instances and a set of queries which hits each one?

Thanks,
Thomas Received on Thu Dec 24 1998 - 19:18:37 CST