Hi. Hope everyone doing great.
When i run SELECT 'X' FROM PS_INSTALLATION this it's taking no time, and when i run the inner query it's taking 3 sec. But when i run the compete query it's taking 2 mins. This is system generated built-in query i can't change the query. Execution plans for the...