How to test speed with SQL query

[1190_5939_439]

Hi Expert

The runtime is 30.547. I am not sure the speed is fast or slowly? Can you help me ?

[Patrick_vN]

At first glance, having to wait around 30 secs for 480 records, doesn't feel fast. But I have no idea what is in these custom tables you're using (are you selecting on key fields, how many records are in the tables,..etc). Which makes it kinda hard to give solid advice.

Could you maybe indicate why you ask the question? Is there a problem of some sorts?

[MateuszAdamus]

Hello

You need to provide at least basic information about the tables you're selecting data from (like Primary Key, possible indices?). Otherwise it's hard to give any advice.

Also, SQL query execution plan would be nice to look at.

Kind regards,

Mateusz

[former_member660513]

Also how do you measure? What is the logic behind that custom report, and did you do a measurement with an official tool - ST05?

[Sandra_Rossi]

And also what database software do you use? (and as Mateusz said, please provide the Execution Plan)