Optimized Search method for DB files. ?

[Prabhu.Chella@xxxxxxxx]

I need some help, in deciding the best method for accessing ,
searching(chaining etc. etc )  a huge database.

Actually we have a plan to introduce a concept, wherein the DB might
contain data from more than one company in the same AS/400 DB.
Say,     If the DB of each Company had Employee first name, last name
.......   Now it would have an additional
field(1'st key field in all the DB's) which will determine to which company
the data belongs to .

E.g.   Before   2 companies say A and B had data like   this
A:
Mark            Smith
Timothy      Dalton
B:
Thomas      Cook
Edwin           moses

Now  it would be in a single DB in a common place ..
(New
Field)
100     Mark            Smith
100    Timothy      Dalton
200    Thomas     Cook
200     Edwin         Moses

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.







+---
| 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
+---