阅读背景:

选择使用EXECUTE并在postgres中重写类似的查询

来源:互联网 

I have virtually the same join query, the difference between my ( >two ) queries being one of the tables on which the join is made. Performance-wise is it better to: 1)rewrite the queries (in one stored procedure ?) OR 2)pass the table on which the join is made as a parameter in a stored procedure (written in plpgsql BTW) and run the query using EXECUTEI have virtually the same join query, the diffe




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: