When I tried to optimize a query using SQL Optimizer 8.0 with a server qualifier, I get the following message:
"Qualifying table with a server name is not supported in this version."
I'm using a linked server so without the server qualifier, SQL Optimizer throws the following error:
“Invalid SQL statement. Table does not exist.”
WORKAROUND: To optimize query with linked server, login to the linked server and remove the linked server part from the query. This is because there is no difference on the actual query plan when SQL Server execute the query with or without the server name.
STATUS: An enhancement request has been submitted for a future release of SQL Optimizer for SQL Server
NOTE: Once server qualifier is supported, linked sever should be support but linked sever to other platform (like Oracle) will not be support. You will need to use SQL Optimizer for other platforms for those jobs.
