@isoutamo  do you want me to try 2 version of queries which you have provided and check execution times? ... View more

@yuanliu Thanks for the suggestion. ... View more

@isoutamo Thank you so much. It works. ... View more

  @isoutamo  My search returns following table. get_01_manage_tps get_01_manage_avg get_01_manage_p90 get_01_manage_p95 get_02_settings_avg get_02_settings_p90 get_02_settings_p95 get_02_settings_tps get_03_devices_avg get_03_devices_p90 get_03_devices_p95 get_03_devices_tps 0.05 1.642 10.083 10.092 0.247 0.269 0.278 0.03 0.333 0.45 0.517 0.23   After transpose , it looks like below which is not correct. API tps avg p95 p90 et_01_manage   1.642     et_02_settings   0.247     et_03_devices   0.333     get_01_manage 0.05   10.092 10.083 get_02_setting 0.03       get_02_settings     0.278 0.269 get_03_device 0.23       get_03_devices     0.517 0.45   My table should look like below.   API tps avg p95 p90 get_01_manage 0.05 1.642 10.092 10.083 get_02_settings 0.03 0.247 0.278 0.269 get_03_devices 0.23 0.333 0.517 0.45 ... View more

@isoutamo Thanks for the reply. Your query works if i give naming convention like Request1, Request2 etc. If i change Request1, Request2 to something else and it does not work. Can you please help. ... View more