Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Help SQL Statement
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
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