Posted by Madhivanan on 11/24/05 16:12

UNION ALL is more efficient that UNION as UNION will unnecessarily
select Distinct and Order the data

Madhivanan

• Next in forum: Re: Query Retrieval is slow
• Prev in forum: Re: 100 % CPU Usage
• Thread view: Re: SQL View Performance

[Reply to this message]