"How'd they do that?" <rmcgorman_usenet@n__o__s__p__a__m__spamex.com> wrote
in message news:kK3yb.524996$9l5.394375@pd7tw2no...
> You could consider forcing the index with the following syntx:
>
> This might remedy your current Production problem however it's a
> double-edged sword in that you are permanently (until you remove it)
> over-riding the optimizer, so if the fastest access plan were to change
> down the road, you wouldn't use it. I'd only consider this as a stop-gap
> measure until you can determine the underlying issue (hopefully others
> will speak to that).
>
> Here's a link to a Sybase whitepaper that discusses forceindex.
>
> http://www.sybase.com/detail?id=2602#538896

Sorry. Forgot to say. We temporarily changed the sql to force the index, as
you've suggested.

Martin