We have some data warehouse Quires, I improved performance these of Quires  with help of indexes. Still client not happy about it's performance .

So want to analyze it's wait events to find performance issues.