Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
--0-796892935-1086702622=:69223
Content-Type: text/plain; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
One of my clients is doing an outer join between a synonym to a database and table in the same instance with a local table. The synonym is the master table. Is there any reason why this query would be much slower than a normal?
Any ideas much appreciated.
Malcolm
--0-796892935-1086702622=:69223
Content-Type: text/html; charset=iso-8859-1
Content-Transfer-Encoding: 8bit
<DIV>One of my clients is doing an outer join between a synonym to a database and table in the same instance with a local table. The synonym is the master table. Is there any reason why this query would be much slower than a normal? </DIV>
<DIV> </DIV>
<DIV>Any ideas much appreciated.</DIV>
<DIV> </DIV>
<DIV>Malcolm</DIV>
--0-796892935-1086702622=:69223--
sending to informix-list
↪ replying to =?iso-8859-1?q?malcolm=20weallans?=
Madison Pruet — — source: Usenet: comp.databases.informix
I wouldn't expect a synonym to have any significant impact on performance.
A synonym is basically a substitution to the query parser.
M.P.
"malcolm weallans" <malcolm.iiug@btopenworld.com> wrote in message
news:ca4he3$888$1@news.xmission.com...
>
> --0-796892935-1086702622=:69223
> Content-Type: text/plain; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> One of my clients is doing an outer join between a synonym to a database
and table in the same instance with a local table. The synonym is the
master table. Is there any reason why this query would be much slower than
a normal?
>
> Any ideas much appreciated.
>
> Malcolm
>
> --0-796892935-1086702622=:69223
> Content-Type: text/html; charset=iso-8859-1
> Content-Transfer-Encoding: 8bit
>
> <DIV>One of my clients is doing an outer join between a synonym
to a database and table in the same instance with a local table.
The synonym is the master table. Is there any reason why this query
would be much slower than a normal? </DIV>
> <DIV> </DIV>
> <DIV>Any ideas much appreciated.</DIV>
> <DIV> </DIV>
> <DIV>Malcolm</DIV>
> --0-796892935-1086702622=:69223--
> sending to informix-list
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.