How do we speed up TDV querries for Salesforce which are using UNION

[Naweed Raja]

How do we speed up TDV querries for Salesforce which are using UNION with Seibel.

 

SELECT A.CaseNumber as TicketNumber,

A.Status as TicketStatus,

A.AccountId as Account,

A.product__c as Product,

A.Subject as ShortDescription,

A.Description as LongDescription,

A.Reason as TicketCategory,

A.CreatedDate as CreatedDate

from /shared/POC/CASE_SF A

UNION ALL

SELECT B.TicketNumber as TicketNumber,

B.TicketStatus as TicketStatus,

B.ACCOUNT as Account,

B.PRODUCT as Product,

B.ShortDescription as ShortDescription,

B.LongDescription as LongDescription,

B.TicketCategory as TicketCategory,

B.CreatedDate as CreatedDate

from /shared/POC/SeibelAll B