Skip to Content (Press Enter)
UserImage.jpg
Edwin van Geene
10Views
5Comments
SQL statement of an aggregate
Question
How and where can I see what SQL has been generated and executed by an aggregate?
I need this to tune my statement which accesses over one million records.
0
0
25 Mar 2015
Copy Link
2018-05-16 11-16-36
João Heleno
 
MVP
If you have Service Studio 9.0.0.36 you can now see the last Executed SQL.


0
0
25 Mar 2015
Copy Link
UserImage.jpg
Edwin van Geene
Ok thanks, I will upgrade to 9.0.0.36
0
0
25 Mar 2015
Copy Link
2024-12-17 14-32-59
Matthias Preuter
 
MVP
0
0
26 Mar 2015
Copy Link
2017-07-05 18-13-21
Tiago Neves
However OutSystems still has the file available for download.
If you're using Windows 8.1 you probably will be ok, just try, if it doesn't work just download the 9.0.0.23.

I am using 9.0.0.36 without any problems.
0
0
26 Mar 2015
Copy Link
2011-09-30 16-44-42
João Fernandes
Edwin,

Keep in mind that the property shows the SQL generated to display the results you are previewing on the Aggregate. It is not the SQL that will be generated for your app.

Generally the SQL that will run is more efficient than what's show on the aggregate because:
  • It will only fetch the columns that you use on your logic/UI;
  • It will limit the number of rows fetched.
Check this post for more info. It's a bit old, but the information is still valid.
0
0
26 Mar 2015
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.