• As I mentioned since both databses are in same instance, the buffer pool is shared, there wont be impact in join performance.

    But normally we split databases for security or functional reasons. For performance, you should try a different aproach like partitioning.

    ----------------------------------------------------------------------------------------------------------------------------------------------------
    Roshan Joe

    Jeff Moden -Forum Etiquette: How to post data/code on a forum to get the best help[/url]