>>>Hi everybody,
>>>
>>>The queue assignment process usually takes ~ 1 min., except for UNASSIGNED BILLER, where it takes ~10 minutes.
>>>
>>>Now, I speculated, that the reason is that we have only small amount of UNASSIGNED BILLER records comparing with other types.
>>>
>>>Can you help me to justify this theory in "scientific" form or do you think I should try to find the bottleneck using Coverage Profiler instead of guessing?
>>>
>>>Thanks in advance.
>>
>>I think you shoud find the bottleneck.
>>Cetin
>
>Thanks <g> I will do it now.
What SYS(3054) said about this SELECT?
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.