SORT OPERATOR

In this article Brian Ellul explorea how it's possible to eliminate the SORT operator (and its performance cost) on performing SELECTS statements.

★ ★ ★ ★ ★ ★ ★ ★ ★ ★

(60)

You rated this post out of 5. Change rating

2010-09-15

11,986 reads

Blogs

I haven’t posted in a while (well, not here at least since I’ve been...

One of the things that I like about the SQL Server docs (MS Learn...

For a number of years I have subscribed to Randy Franklin Smith's Patch Tuesday...

hi we have to replace talend which generally was used to move files. talend's...

hi, i have checked reducing it increasing it but could not get any...

Comments posted to this topic are about the item What is the PRODUCT

In SQL Server 2025, what does this return?

CREATE TABLE Numbers
( n INT)
GO
INSERT dbo.Numbers
(
n
)
VALUES
(1), (2), (3)
GO
SELECT PRODUCT(n)
FROM dbo.Numbers