hi i have two db on the same server

i must query them together.

i make joins between tables of two different databases.

when i run the query on DB_1 the execution plan gives warnings about missing statistics for the tables on DB_2
when i run the query on DB_2 everything is normal query is quick

anyone has an idea about what couses this situation?

sample query without warning about DB_2

use DB_2

select t1.c1, t2.c1,t3.c2,t4.c3
from
server.DB_1.dbo.table1 t1
join table2 t2 on t2.c3=t1.c1
join server.DB_1.dbo.table3 t3 on t3.c2=t2.c4 and t1.c5=t3.c4
join table4 t4 on t4.c4=t2.c3



sample query with warnings about DB_2

use DB_1

select t1.c1, t2.c1,t3.c2,t4.c3
from
table1 t1
join server.DB_2.dbo.table2 t2 on t2.c3=t1.c1
join table3 t3 on t3.c2=t2.c4 and t1.c5=t3.c4
join server.DB_1.dbo.table4 t4 on t4.c4=t2.c3





MS Sql Server LazyDBA home page