SQL Statment

Article View: comp.databases.oracle.misc

Article #126

Back to comp.databases.oracle.misc Previous Next

#126

From: Daniel Cukier
Date: Wed, 16 Jun 1999 00:00

19 lines
1423 bytes

Is there anything wrnog with this SQL statment?

"select rep.repnomfan, sum(pedtotinf) venda
from puket.avpeca, (select repcod, repnomfan from puket.coreca where
repstacod = 'A') rep
where rep.repcod = avpeca.repcod
group by rep.repnomfan
order by venda"

table puket.avpeca has 35000 rows

the search takes 6 secons. It is normal?


-----------------------------------------------
Daniel Cukier
danicuki@linux.ime.usp.br
UIN: 5570114
-----------------------------------------------

Technical Details

Message-ID: <7k8vrg$2qls@enews3.newsguy.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fb53f,5fe1e418263968a5,start
X-Google-Attributes: gidfb53f,public
X-Google-Thread: fa4f9,5fe1e418263968a5,start
X-Google-Attributes: gidfa4f9,public
X-Google-Thread: f99a8,5fe1e418263968a5,start
X-Google-Attributes: gidf99a8,public
X-Google-Thread: 10747e,5fe1e418263968a5,start
X-Google-Attributes: gid10747e,public
X-Google-Thread: 1143a7,5fe1e418263968a5,start
X-Google-Attributes: gid1143a7,public
From: "Daniel Cukier" <danicuki@linux.ime.usp.br>
Subject: SQL Statment
Date: 1999/06/16
Message-ID: <7k8vrg$2qls@enews3.newsguy.com>
X-Deja-AN: 490402918
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: http://extra.newsguy.com
X-MSMail-Priority: Normal
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.server,comp.lang.basic.visual.database,hannover.uni.comp.oracle,relcom.comp.dbms.oracle