Hi Gregory,
I raised a question, why do we have to go through all these troubles to get the Commission Owner (=Investigator) for the account. It would be logical to keep this field in the Trans table instead. So right now we're discussing this idea. So, the whole optimization idea becomes mute, if this information would be in Trans table.
>>Hi Gregory,
>>
>>I think, it works fine right now, so I am not sure, if further optimization is required.
>>
>hi Nadya,
>
>I think it's worth trying it. The speed may not improve much this time, but it will be an experience for the next time ;-)
If it's not broken, fix it until it is.
My Blog