Do synonyms affect perrmance?
--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
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