The performance recorder is the easiest way to do this.
You may need to refresh your data source to make sure the queries aren't just cached.
Also, if your queries are really fast, you may need to move the slider in the performance recorder to 0 so that all events show up.
Queries will show up as green bars. Click on one of them to see the query text at the bottom of the performance recording.
You can also read the logs but that's a lot more work.
Thank you for the reply .So each time after start of the performace recording do I need to refresh the data source for getting the query.
Also what if it is an extract ,there also Do I have to follow the same process.
Thanks in advance.
Yes, you should start the recording and then refresh the data source. It's the easiest way to make sure the result isn't cached.
If it's an extract and you want to see the query sent to create the extract, then you need to refresh the extract. If you just want to see the queries sent to the extract, then just a regular refresh is fine.
Thank you so much Dan for guiding me on this topic..:)