View Between Tables In Different Databases

We have created a view that selects from tables in two databases. it looks like something like this:



CREATE VIEW myview AS

SELECT col FROM db1.mytab

UNION SELECT col FROM db2.mytab;



Both tables have col as primary key.



When we executes SELECT col FROM myview WHERE col='SOMEVALUE' we receives the correct result but SQL server does not use any indexes. It performs a index scan on both tables. Wh and what can we do about it? The tables contains millions of rows so the performance is terrible.



The following works fine:

SELECT col FROM db1.mytab WHERE col ='SOMEVALUE'

UNION SELECT col FROM db2.mytab WHERE col ='SOMEVALUE';



Qe are running SQL Server 2000 and TRANSACT SQL



Best regards

/Ingvar