Re: sql - why doesn't the query engine know this???

[Dan <dan27649@xxxxxxxxx>]

I was going to suggest the same thing (with the added instruction to rerun
the original query back-to-back immediately), but Gerald indicated that he
had built all of the advised indexes.  Shouldn't that preclude the need for
the DB engine to build any other temporary indexes?

- Dan

On Thu, Jun 18, 2015 at 3:25 PM, Koester, Michael <mkoester@xxxxxxxxxxxxx>
wrote:

> I'm no expert on SQL performance issues, but for a WAG I'd suggest that if
> you now take the parens away and try your original statement again w/o
> them, you might find it acceptably speedy.  Thinking that your 30 minute
> run sufficiently trained the SQL engine.  Which is why you had such amazing
> results with the other variants?
>
> Maybe?
>
> Enjoy,
> --Michael Koester