The remote server requires a proxy table to process a relocated join. If a proxy table does not exist in advance, one is created automatically when the query is processed. When a relocated join query is received by the remote server, the current database is searched for an existing proxy table that has the same remote mapping as the table referenced in the relocated statement. If no proxy table exists with same mapping in the current database, then tempdb is searched. If no match is found there, then a proxy table is created dynamically in tempdb.
To avoid the overhead in dynamically creating a proxy table, Sybase recommends that you create proxy tables for each table that may be referenced in a relocated join.
