Re: Performance and timestamp fileds

If you run the following, does it speed up?

CREATE INDEX mylib/myfileLF ON mylib/myfilePF (RECSTATE, DATEDOC, 
MODIFIED) 
and you can add any field to the end that may be on your ORDER BY clause.

Rob Berendt
-- 
"They that can give up essential liberty to obtain a little temporary 
safety deserve neither liberty nor safety." 
Benjamin Franklin 




Marco Facchinetti <facchinetti@xxxxxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
05/15/2003 10:23 AM
Please respond to Midrange Systems Technical Discussion
 
        To:     Midrange Systems Technical Discussion 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        Fax to: 
        Subject:        Performance and timestamp fileds


I'm at V5R2:

Executing a runqry with rcdslt(*yes) on a file with:

RECSTATE       1A
.....
DATEDOC         L
.....
MODIFIED        Z

if the record select is:

    RECSTATE  EQ  ' '
AND MODIFIED  GE  '2003-05-09-00.00.00.000000' 

it takes few seconds, if

    RECSTATE  EQ  ' '
AND DATADOC   LT  '31/13/02'
AND MODIFIED  GE  '2003-05-09-00.00.00.000000' 

it takes 7 minutes.

All the logical files exclude RECSTATE *NE ' '.
There is a logical with the key on DATADOC.
Other logicals don't use DATADOC.

Any idea?


__________________________________
Do you Yahoo!?
The New Yahoo! Search - Faster. Easier. Bingo.
http://search.yahoo.com
_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing 
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.