Re: WHY SQL-Statement without bind-prameters runs 50 times faster as with ??????

From: Karl R. <kreitsch_at_zdnetonebox.com>
Date: 2000/05/03
Message-ID: <05f325eb.06605473@usw-ex0104-031.remarq.com>#1/1

Hy Pat,
Thank you for your Tips, i think the only way is to use dynamic- sql and putting the datevalues directly.

SELECT

KETT.ID ,
KETT.KETTENCODE ,
KETT.NAME ,
KETT.KETTENKLASSE ,
KETT.AUSWEISUNG ,
KETT.FK_ORGP_BETREUT_VON ,

TO_CHAR(KETT.GUELTIG_VON,
'DD.MM.YYYY') ,

TO_CHAR(KETT.GUELTIG_BIS,
'DD.MM.YYYY') ,

KETT.FK_AGEN_ZAHLUNGSEMPF ,
KETT.FK_VERW_ZAHLUNGSEMPF ,
VERW.ID ,
VERW.NAME ,
VERW.SHORT_ID ,
VERW.PLZ ,
VERW.ORT ,
VERW.FK_ORGP_BETREUT_VON ,
VERW.FK_KETT ,
VERW.VERW_TYPE ,
VERW.FK_VERW_ZENTRALE ,

TO_CHAR(VERW.GUELTIG_VON,
'DD.MM.YYYY') ,

TO_CHAR(VERW.GUELTIG_BIS,
'DD.MM.YYYY') ,

ORGP.CODE
FROM
KETT ,
VERW ,
ORGP
WHERE

KETT.ID=VERW.FK_KETT and
ORGP.ID=VERW.FK_ORGP_BETREUT_VON and
KETT.KETTENKLASSE='M' and
KETT.GUELTIG_BIS >='17-APR-00' and
KETT.GUELTIG_VON <= '17-APR-00'and
ORGP.GUELTIG_BIS >= '17-APR-00' and
ORGP.GUELTIG_VON <= '17-APR-00' and
VERW.GUELTIG_BIS >='17-APR-00' and
VERW.GUELTIG_VON <='17-APR-00'

order by KETT.KETTENCODE,KETT.NAME,VERW.FK_VERW_ZENTRALE desc ,VERW.SHORT_ID

Karl Reitschuster
Senior Consultant CSC Ploenzke AG
Oracle Databases, Implementation, Performance-Tuning <!Jesus is Lord!>
* Sent from RemarQ http://www.remarq.com The Internet's Discussion Network * The fastest and easiest way to search and participate in Usenet - Free! Received on Wed May 03 2000 - 00:00:00 CDT