Subject Another optimizer :-)
Author Claudio Valderrama C.
This is from Sybase newsgroups. ASE is Adaptive Server Enterprise:

Created by Newsgroups
on 01/18/2001 at 12:42 PM sybase.public.sqlserver.nt

problem with query optimizer

We have a version ASE 11.9.2/1031/P/NT(ix86)/03
Our queries become real slow by time even we update statistics every day.
When check plan with showplan we find totaly different showplan for the
query comparing with showplan when query ran well, then we have to add dummy
index to revert to old good showplan and then drop dummy index and after a
month same thing happens again.
Is this Sybase internal bug in this release or what?


Doesn't it sound somewhat familiar? It seems that we aren't alone with a
tricky optimizer. ;-)

Claudio Valderrama C.
Ingeniero en Informática - Consultor independiente