Hi,
Kindly provide some inputs on this situation
Table:
grp_id e_number date
1 123 12-10-2003
1 124 11-10-2003
1 134 10-10-2004
2 11 11-11-2002
2 14 12-11-2003


grp_id,e_number,date is primary key

This table contains around 170 Million recs... I need to pick record where the max date for a group number is <=against a supplied date
this record needs to be joined with another table on the basis of grp_id.. If I use a correlated query the process simply hangs... Is there any better way of doing it..
Pls give your valuable inputs..

Thanks and Regards



Confidentiality Notice

The information contained in this electronic message and any attachments to this message are intended
for the exclusive use of the addressee(s) and may contain confidential or privileged information. If
you are not the intended recipient, please notify the sender at Wipro or [Email address protected] immediately
and destroy all copies of this message and any attachments.

Oracle LazyDBA home page