Re: Query takes around 15 to 20 min over 20Lakh rows

El día lunes, septiembre 06, 2021 a las 11:45:34p. m. +0530, Shubham Mittal escribió:

> 20 Lakh is the current no of rows in the task table.. on which the query is
> executed..

Ahh, I never came accross this (Indian) unit 'lakh' and now understand
that we're are talking about https://en.wikipedia.org/wiki/Lakh 
and 20 Lakh are only 2.000.000 rows, which isn't a very big number.

Can't help with your query, though.

    matthias


-- 
Matthias Apitz, ✉ guru@unixarea.de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
August 13, 1961: Better a wall than a war. And, while the GDR was still existing,
no German troups and bombs have been killed in Yugoslavia, Afghanistan, Afrika...