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 : > > > I have created the decode, NVL and DIVIDE fu

[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, '-'