[Info-ingres] A Really Slow Query

[Karl and Betty Schendel]

> On Oct 18, 2018, at 6:55 PM, Michel Forget <mvf at cyberren.com> wrote:
> 
> Hi,
>  
> I'm having a problem with the performance of a query and I'm hoping someone can help.
>  
> The main problem is that this query takes literally minutes to run.  Looking at the QEP, things seem to go off the rails in the lower right-half of the QEP.  There is a huge chunk of CPU time on the right-join to the proj-rest node that got data from secondary index alt2_d4.  There is also then a huge burst of disk time when it appears Ingres is pulling more data from base table d4.
>  

What's the QE90 output look like?

Karl