Is it possible to copy an oracle table into a pl/sql table for lookups?

We have a stored procedure that will process around 10 million rows. for each record it has to do a lookup against an oracle table T1 of the following structure

bill_group      bill_month      1st read        2nd read        3rd read       
 9                      1               01/02           01/03            01/05

select bill month from T1 where bill group =:bg and 1st date =:date1

Rather than do 10 million selects I would like to create a pl/sql table that would have the same structure and then do lookups against it like an array. I am assuming this would be much faster than doing selects.

Any ideas? Received on Tue Apr 25 2000 - 00:00:00 CDT