Re: 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
>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
>
>

Create indexes on the table, using the columns referenced in the WHERE clause.

Dan Hekimian-Williams Received on Sat Jun 27 1998 - 05:22:31 CEST