|Subject||Re: Trying to fix slow query|
> >That is where I am getting confused, am I supposed to remove myoptimize
> >Foreign Key constraints, and add new indices, and then I can
> >my queries?constraints,
> Nooooooo!!!! I wasn't suggesting you remove *all* of your FK
> only these "lookup" style ones that cause badly-performing queries.special
> The point being made was that, if you want to force the use of your
> index, rather than the one chosen by the optimizer, then yourchoices are
> to remove the FK (which in this case makes sense) or to use acustom plan.
Thanks for the nice explanation!!! I am beginning to see the light...
Do you cover this in your book? .... I can't wait to receive it!!!
I will spend some quality time with the db in question today and will
report back the results.