I am trying to figure out what to use, DB Links or Synonyms, which is better in performace? why would one choose one over the other?
In DB Link, remote server connections in MSSQL they need to be in the format select * from [ServerName].[DatabaseName].[SchemaName].[TableName], i.e. if you need to
switch between two servers (say Production and Test) you only need to recreate the LinkedServer.
however, with Synonyms also, for switching, you need to create the synonymns in the environment.
If anyone can point me to article or something that shows performance and usage in context of both it would be really helpful.
View Complete Post