CRXI - Union All Command TREAKING?

[CRXIuser2005]

Does it matter as to the order of the data elements within a UNION ALL statement... in regard to enhancing the SPEED of the processing?

My union all command takes about 1 hours to process, granted I can live with this time frame, I'm just wondering if union all statements can be tweaked in someway to enhance the speed of the processings???


Thank you.

MV

"A man is only as happy, as he makes up his mind to be....

 

[IdoMillet]

No, the order of data elements doesn't make a difference. The order of table names in the WHERE clause may make a difference in some DBMSs.

Find the SELECT within the UNION that takes a long time (run them individually) and improve that SELECT by considering indexing, etc.

Since you are not providing any background, it is difficult to offer a more detailed advice.

hth,
- Ido

Visual CUT & DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com