Re: Help with tuning slow query

2018-05-19 Thread Justin Pryzby
On Fri, May 18, 2018 at 08:32:55PM +, Kotapati, Anil wrote: > We are facing issues with one of our query, when we use order by count it is > taking lot of time to execute the query. To be precise it is taking 9 min to > execute the query from table which has ~220 million records. Is there a

Help with tuning slow query

2018-05-19 Thread Kotapati, Anil
Hi Team, We are facing issues with one of our query, when we use order by count it is taking lot of time to execute the query. To be precise it is taking 9 min to execute the query from table which has ~220 million records. Is there a way to make this query run faster and efficiently using