tag:blogger.com,1999:blog-2377727724851115192.post4092416967860428733..comments2024-03-23T15:56:15.328+05:30Comments on Data is everywhere, but?: Whether to use UNION or OR in SQL Server QueriesDinesh Asankahttp://www.blogger.com/profile/15933617650741277563noreply@blogger.comBlogger1125tag:blogger.com,1999:blog-2377727724851115192.post-4978093126955897472011-07-31T23:13:18.020+05:302011-07-31T23:13:18.020+05:30Group: SQL Server DBA Board
Discussion:Whether to ...Group: SQL Server DBA Board<br />Discussion:Whether to use UNION or OR in SQL Server Queries<br /><br /> Interesting but UNION only advantageous in a scenario I wouldn't recommend; implementing clustered indexes. I always excercise caustion with any clustered index implementation because the forced ordering of the rows is only any good with range lookups and can increase the costs of other queries. It has always annoyed me that the default position in SQL Server is a clustered index on an Identity column - largely useless! <br />Posted by John ThorpeDinesh Asankahttps://www.blogger.com/profile/15933617650741277563noreply@blogger.com