Re: Slow sql

From: Rukmini Devi <rukmini_at_indbrain.com>
Date: Thu, 16 Aug 2001 03:21:58 -0700
Message-ID: <F001.0036CA5B.20010816032804@fatcity.com>

Hi,

it must be doing full table scan.check your column positions of the indexes in table user_ind_columns and change your where condition according to the column positions.

rukmini
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, August 16, 2001 3:15 PM

Hallo you DBA'¨s

Can anyonetell me why this insert statement takes 30-40 minutes to run? What can I do to make it go faster?

insert into varukorgtemp ( varukorgid, ean, anvandarid, lagstapris, varutyp, varunamn, strl, leverantor, varumarke,
sortiment,vgrp,vare_snr,varenr,levnr )

        SELECT PBK.VARUKORGEANREL.varukorgid, rik2.vare.ean_nr, 'rsm' ,
           PBK.VARUKORGEANREL.lagstapris, 0, rik2.vare.varenavn,
rik2.vare.str,
           rik2.lev.navn, rik2.vare.hylletxt2,

rik2.vare.sortiment,rik2.art_hierarki.vgrp,

pbk.varukorgeanrel.vare_snr,pbk.varukorgeanrel.varenr,pbk.varukorgeanrel.lev nr

         FROM PBK.VARUKORGEANREL,rik2.vare,rik2.lev,rik2.art_hierarki
         WHERE PBK.VARUKORGEANREL.varukorgid= 39
         AND PBK.VARUKORGEANREL.ean=rik2.vare.ean_nr
         AND RIK2.VARE.ARTNR=RIK2.ART_HIERARKI.ARTNR
         AND rik2.vare.levnr=rik2.lev.levnr
         AND rik2.vare.selskap='11'
         AND rik2.vare.vare_snr=pbk.varukorgeanrel.vare_snr
         AND pbk.varukorgeanrel.varenr=rik2.vare.varenr
         AND pbk.varukorgeanrel.levnr=rik2.vare.levnr
         AND rik2.art_hierarki.sett_id=2

Sincerely

Roland Sköldblom

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
  INET: Roland.Skoldblom_at_ica.se

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rukmini Devi
  INET: rukmini_at_indbrain.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L


(or the name of mailing list you want to be removed from).  You may

also send the HELP command for other information (like subscribing).

Received on Thu Aug 16 2001 - 05:21:58 CDT