[ADMIN] Query to slow

2003-08-25 Thread Rhaoni Chiu Pereira
Hi List, As I said before, I'm not a DBA yet , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows : SELECT /*+ */ ftnfco00.estado_cliente , ftcofi00.grupo_faturamento , SUM( DECODE( ftcofi00.atual_fatura, '-',

Re: [ADMIN] Query to slow

2003-08-25 Thread Robert Treat
On Mon, 2003-08-25 at 08:17, Rhaoni Chiu Pereira wrote: Hi List, As I said before, I'm not a DBA yet , but I'm learning ... and I already have a PostgreSQL running, so I have to ask some help... I got a SQL as folows : snip I have created the decode, NVL and DIVIDE