RE:Optimized Search method for DB files. ?

[John Carr <74711.77@xxxxxxxxxxxxxx>]

Date:   10/22/98  1:07 PM

RE:     Optimized Search method for DB files. ?


>I need some help, in deciding the best method for accessing ,
>searching(chaining etc. etc )  a huge database.
<SNIP>
>So now the size of the database will be increasing by the no of companies
>combined together.  The Size of the DB will be very large in most of the
>cases (We need to optimize the accessing, searching of  these DB's).
>Can anyone help us out by providing some good tips for tackling this
>problem !!!!! ..
>Thanks in Advance ,
>Chellaprabhu.


What release of OS/400 ?

With V4R3  we now have "Encoded Vector Indexes"(EVI).   It can reduce
(say) a  30Gig index to about 2Gigs.  Its real fast and is used by the
Query engine on the AS/400 by all products(I think).  

http://www.news400.com/x/v4r3/DB.htm

(http://www.ontopofit.com/articles/980908/1141246.shtml)


In addition,  Of course have indexes by Company, Name, etc
and also Name,Company, etc

John Carr
EdgeTech
Have Classes, Will Travel
804-739-7689
+---
| This is the Midrange System Mailing List!
| To submit a new message, send your mail to MIDRANGE-L@midrange.com.
| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com.
| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com.
| Questions should be directed to the list owner/operator: david@midrange.com
+---