On 7/11/07 8:55 PM, "Joe Wilson" <[EMAIL PROTECTED]> wrote:
> The problem is schema design.
> Just use a single task table with another key column for the task number.
> Queries on N task tables with UNIONS are killing your performance.
>
But how do I associate processes to different tasks having some Task_Name
'XYZ' stored under Task with some Task_Number.
Thanks for any assistance,
Bharath Booshan L
-----------------------------------------------
Robosoft Technologies - Come home to Technology
Disclaimer: This email may contain confidential material. If you were not an
intended recipient, please notify the sender and delete all copies. Emails to
and from our network may be logged and monitored. This email and its
attachments are scanned for virus by our scanners and are believed to be safe.
However, no warranty is given that this email is free of malicious content or
virus.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------