Categories

JavaScriptPHPHTMLCssPythonWordPressWeb developmentLinuxMySQLAndroidWindowsJavaC++ / C#LayoutReactUbuntuYiiDjangoProgramming1C-BitrixLaravelSystem administrationTelegramJSONDebianPostgreSQLIOSGoogleHtaccessWindows ServerGitMacOSGoogle ChromeCMSWooСommerceBootstrapNginxSQLUnityAPI
Make a leaderReport
V
V
Vitaly Rybchenko2017-07-14 14:55:41
SQL Server
Vitaly Rybchenko, 2017-07-14 14:55:41

Why is sorting performed?

Good day everyone!
I noticed a significant slowdown in the execution of the request.
I noticed that sorting eats 54%. Why is it performed? Are these some of my settings / indexes that are not correct or is this the ms sql approach when joining?
Screenshot

Reply
Answer the question

Answer the question

In order to leave comments, you need to log in

1 answer(s)
Report
S
Sergey Gornostaev, 2017-07-14
@sergey-gornostaev

For group by.

Similar questions
A
Andrey R2015-12-04 13:15:58
How to write Subquery in Doctrine Query Builder? 1Reply
K
kinitko2012-09-03 11:50:51
Where can I find a script template in Microsoft SQL Management Studio 2008? 1Reply
S
Shedal2012-09-20 14:50:53
[SSAS] Generic calculation measure (perhaps using a stored procedure)? 1Reply
B
bsd92015-12-13 12:47:12
Is it possible to write an UPDATE that will update the id values? 1Reply
S
SerPro2012-10-24 11:19:03
How to backup MS SQL 2008 R2 with FILESTREAM. Base separately, files separately? 2Reply

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question