• I figured it out. When creating the synonym I needed two dots after linked server name:

    CREATE SYNONYM FISVEND

    FOR DOA_FANS..FIS.VENDORS_V

    GO

    However...running the query from openquery took 39 seconds to return 215,848 rows BUT running the query with synonym took 2 min 52 seconds. Any ideas why?