General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
>>About when UNION ALL is slower than UNION kill me I don't know. My first answer is "NEVER" but I suspect that if there is such a question maybe there are occasions when that statements is true. Maybe for huge tables and proper indexes the filtering could be faster than just APPEND, but as I said I am not sure at all.
>
>I also answered that UNION ALL is faster and also was puzzled where UNION ALL would be slower. The answer was when UNION would return a huge result set the UNION ALL might be slower, I never verified this, BTW.
>
YEAH!!!!!!
Finally guessed correctly on a tech question I knew almost nothing about.
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only