Chris Kratz wrote:
Hello All,
We are struggling with a specific query that is killing us. When doing
explain analyze on the entire query, we *seem* to be getting killed by the
estimated number of rows on a case statement calculation.
I've included a snippet from the explain analyze of the
Hello Richard,
Thank you for the response. I did forget to mention that the columns have the
following meanings.
One, if a begin or end date is null, it means that the role is open ended in
that direction. For example, if there is no end date, that means currently
the role will go on
Hello All,
We are struggling with a specific query that is killing us. When doing
explain analyze on the entire query, we *seem* to be getting killed by the
estimated number of rows on a case statement calculation.
I've included a snippet from the explain analyze of the much larger query. The