Re: Can I do this with one queryThis is a discussion on Re: Can I do this with one query within the sqlserver-programming forums in Microsoft SQL Server category; Cute! I wonder what the performance is like. I was surprised a few years ago when I found that MINUS, the Oracle version of EXCEPT, was really fast for doing relational divisions.... | ||||||||
| | ||||||||
| ||||||||
| Register | FAQ | Calendar | Search | Today's Posts | Mark Forums Read |
|
#1
08-27-2008, 10:00 AM
|
 Re: Can I do this with one query Cute! I wonder what the performance is like. I was surprised a few years ago when I found that MINUS, the Oracle version of EXCEPT, was really fast for doing relational divisions.  |
|
#2
08-28-2008, 01:13 AM
|
| Re: Can I do this with one query --CELKO-- wrote: > Cute! I wonder what the performance is like. I was surprised a few > years ago when I found that MINUS, the Oracle version of EXCEPT, was > really fast for doing relational divisions. Would be interesting - maybe I'll get some time to test this out. |
|
#3
08-28-2008, 10:18 AM
|
| Re: Can I do this with one query On Aug 27, 6:00*am, --CELKO-- > Cute! I wonder what the performance is like. *I was surprised a few > years ago when I found that MINUS, the Oracle version of EXCEPT, was > really fast for doing relational divisions. In general, I have found EXCEPT on SQL Server to be about on par with UNION (which makes sense to me). I use EXCEPT a lot for investigating data, where it is enormously useful. |
 |
« Previous Thread
|
Next Thread »
| Thread Tools | |
| Display Modes | |
Linear Mode
All times are GMT -4. The time now is 07:47 PM.
