Performance Advice - Master/Detail Select
From: Donna Morrow <morrowd_at_ci.portsmouth.va.us>
Date: 1997/05/23
Message-ID: <01bc67bc$9d884f80$1e01070a_at_Donna.ci.portsmouth.va.us>#1/1
Date: 1997/05/23
Message-ID: <01bc67bc$9d884f80$1e01070a_at_Donna.ci.portsmouth.va.us>#1/1
Hi everyone! --- Need some opinions
Design is thus:
Master record m1
Detail records d1
I frequently need to access the most recent (i.e. maximum seq no) detail record for a specified master record. I need to retrieve several columns which store date and balance amounts in order to calculate the balances of the next detail record.
Is there an efficient way of doing this in one SQL statement or would I be better to duplicate these balance amounts in the master record?
Looking for Guidance
Donna Received on Fri May 23 1997 - 00:00:00 CEST