RE: Events Processing - 6004 HP/Infx

["Mark Curtis" <mark.curtis@xxxxxxxxxxxx>]

George,

Yes, but good guess.

We regularly export, drop and import the dB to get around the extent
problems
inherited from the prime database (initial & next extent of 16).

With a dbexport/dbimport most (!!!but not all!!!) tables including glh have
an update stats done.

The Select
----------

SELECT

lhid,lhldgr,lhbook,lhyear,lhperd,lhjnen,lhjnln,lhian,lhdram,lhcram,lhdrat,l

hcrat,lhlsts,lhstat,lhldes,lhjrf1,lhjrf2,lhdref,lhddat,lhreas,lhbkov,lhuser

,lhdate,lhtime,lhlock,lhsumf,lhsln,lhtsn,lhtrnn,lhdrmr,lhcrmr,lhstmr,lhjnml
     FROM GLH WHERE (LHLDGR BETWEEN ? AND ? AND LHBOOK BETWEEN ? AND ? AND
    LHYEAR BETWEEN ? AND ? AND LHPERD BETWEEN ? AND ? AND LHJNEN BETWEEN ?
AND
    ? AND LHJNLN BETWEEN ? AND ? AND LHID = ? AND LHLSTS BETWEEN ? AND ?)
    ORDER BY LHLDGR,LHBOOK,LHYEAR,LHPERD,LHJNEN,LHJNLN

The dbexport SQL
----------------

update statistics high for table glh

     lhbkov, lhbook, lhcram, lhcrat, lhcrmr,
     lhdate, lhddat, lhdram, lhdrat, lhdref,
     lhdrmr, lhian, lhid, lhjnen, lhjnln,
     lhjnml, lhjrf1, lhjrf2, lhldes, lhldgr,
     lhlock, lhlsts, lhperd, lhreas, lhsln,
     lhstat, lhstmr, lhsumf, lhtime, lhtrnn,
     lhtsn, lhuser, lhyear, serialcolumn)
     resolution 0.50000 ;

I belive that if the select uses BETWEEN the engine makes little use of
indexes,
even if (as in this case) the FROM and TO values are the same. Unless
someone else knows better !

Rgds
Mark Curtis

-----Original Message-----
From: owner-bpcs-l@midrange.com [mailto:owner-bpcs-l@midrange.com]On
Behalf Of George Sagen
Sent: 16 June 1999 21:54
To: BPCS-L@midrange.com
Subject: RE: Events Processing - 6004 HP/Infx


Have you tried to update statistics high on the glh for those columns in the
select statement?

George Sagen
BPCS Application Consultant
gsagen@primesourcetech.com <mailto:gsagen@primesourcetech.com>
http://www.primesourcetech.com
PrimeSource Technologies
7373 East Doubletree Ranch Road
Suite 150
Scottsdale, AZ 85258
(801)360-6360 Direct & VM
 


.  -----Original Message-----
.  From: uucp@Uucp1.mcs.net [mailto:uucp@Uucp1.mcs.net]On Behalf Of Mark
.  Curtis
.  Sent: Wednesday, June 16, 1999 7:23 AM
.  To: BPCS-L@midrange.com
.  Subject: Events Processing - 6004 HP/Infx



+---
| This is the BPCS Users Mailing List!
| To submit a new message, send your mail to BPCS-L@midrange.com.
| To subscribe to this list send email to BPCS-L-SUB@midrange.com.
| To unsubscribe from this list send email to BPCS-L-UNSUB@midrange.com.
| Questions should be directed to the list owner: dasmussen@aol.com
+---