Re: [PERFORM] Performance of UNION vs IN

Le 20/03/2014 18:13, Torsten Förtsch a écrit : On 20/03/14 17:57, Jean-Max Reymond wrote: I have a very complex view zinfoexp and running the view as: SELECT * FROM zinfoexp WHERE idmembre in (1,84) take 2700 ms So, I try another syntax: SELECT * FROM zinfoexp WHERE idmembre = 1 union SELECT

Re: [PERFORM] Performance of UNION vs IN

On 20/03/14 17:57, Jean-Max Reymond wrote: > I have a very complex view zinfoexp and running the view as: > SELECT * FROM zinfoexp WHERE idmembre in (1,84) > take 2700 ms > > So, I try another syntax: > SELECT * FROM zinfoexp WHERE idmembre = 1 > union > SELECT * FROM zinfoexp WHERE idmembre =

[PERFORM] Performance of UNION vs IN

I have a very complex view zinfoexp and running the view as: SELECT * FROM zinfoexp WHERE idmembre in (1,84) take 2700 ms So, I try another syntax: SELECT * FROM zinfoexp WHERE idmembre = 1 union SELECT * FROM zinfoexp WHERE idmembre = 84 and for me, two calls to my view takes a lot of time (