We have around 40-50 columns in each of the Query studio report, but when we try to open the Query from portal ( not running the query), it's taking around 20-30 minutes of time.
We don't have similar issue for Report studio.
Any suggestions regarding the performance of Query studio ?
Are you saying it is taking 20 to 30 minutes to launch the Query Studio User Interface? Or is it taking 20 to 30 minutes to run a report you have created in Query Studio?
If it's the latter, try opening the report in Report Studio and looking at how the query (queries?) is defined and see if there is anything different or unexpected being done when the query is created from within Query Studio. Don't save and overwrite the original report in Report Studio, though, or else you will lose the ability to edit it with Query Studio later on.
Regards,
MF.