The 50-table join limit is fully functional with remote servers that support it.
CIS first checks the capabilities of remote servers. If the 50-table join is supported by the remote server, the requested query is passed onto the remove server.If the remote server does not support a 50-table join, a query is sent that references 16 tables or less at a time.
