> I'd like to use the sql exists() function but I'm not sure of it's > performance.
The T-SQL EXISTS() function just returns true or false depending on whether the subquery it is passed returns any rows or not, so its performance is entirely dependent upon the query you pass in to it. I believe a lot of people create examples using "select *" because it's easier to write in sample code. I would write the subquery using the same rules regarding performance that you would any other query to ensure that the server can generate an optimal execution plan and limit the number of pieces of data it has to look at. -Justin Scott ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/sql/message.cfm/messageid:3437 Subscription: http://www.houseoffusion.com/groups/sql/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/sql/unsubscribe.cfm
