Synonym or Not Synonym
From: Mason Liu <lium_at_dspmp001.research.allied.com>
Date: 1996/04/10
Message-ID: <316BE4A8.63CA_at_dspmp001.research.allied.com>#1/1
Date: 1996/04/10
Message-ID: <316BE4A8.63CA_at_dspmp001.research.allied.com>#1/1
What's the pros and cons of using Synonym? Any performance impact since a
synonym may require two table look up? If not using sysnonyms, the table
owner schema must be always attached as a table qualifier, that can be
inconvenient and inflexible for multiple sites.
What's your opinion. Thanks.
Mason