Re: [PERFORM] Performance difference when using views

2004-11-01 Thread Simon Riggs
On Mon, 2004-11-01 at 21:40, Alvaro Nunes Melo wrote: > Hi, > > I have some views that are used to make some queries simplest. But when > I use them there is a performance loss, because the query don't use > indexes anymore. Below I'm sending the query with and without the view, > its execution ti

Re: [PERFORM] Performance difference when using views

2004-11-01 Thread Tom Lane
Alvaro Nunes Melo <[EMAIL PROTECTED]> writes: > I have some views that are used to make some queries simplest. But when > I use them there is a performance loss, because the query don't use > indexes anymore. Below I'm sending the query with and without the view, > its execution times, explains and

[PERFORM] Performance difference when using views

2004-11-01 Thread Alvaro Nunes Melo
Hi, I have some views that are used to make some queries simplest. But when I use them there is a performance loss, because the query don't use indexes anymore. Below I'm sending the query with and without the view, its execution times, explains and the view's body. I didn't understood the why the