Help SQL Statement

From: Ralf Bender <Ralf.Bender_at_wolnet.de>
Date: 1998/06/26
Message-ID: <359401a6.0@dns.wolnet.de>#1/1

Hallo *.*

I'm just a beginner in SQL and hope someone could help me.

I've got a view like this :

select kk.docid as DOCID,

     kk.belegart as Belegart,
     kk.codanummer as CODA,
     kk.kkinhaber as Kreditkarteninhaber,
     kk.kknummer as Kreditkartennummer ,
     kk.datum as Belegdatum,
     kk.company as Company,
     ck.wertkopf as Wert_DM,
     ck.eingdatum as Eing_Datum,
     cp.teilkto as Kostenstelle,
     cp.eben3kto as ProjektNr,
     ck.wertkopf/e.wert as Wert_EURO

from euro e,kkabrechnung kk,codabuchkopf ck,codabuchposition cp where kk.belegart = cp.belegart

     and   kk.codanummer = cp.codanummer
     and   kk.belegart = ck.belegart
     and   kk.codanummer = ck.codanummer
     and   kk.company like '%AG%';

Data are most in following order: cp (60000),ck(10000),kk(2000),e(1)

I think my view is very slow, and there are not many datas for an oracle database. What must/can I do to run it fast ?

Please, explain me what to do.

THANX
ralf

mailto:ralf.bender_at_wolnet.de Received on Fri Jun 26 1998 - 00:00:00 CDT