We've currently come accross a problem with Sybase 11.5 (and 12 I believe)
in that theirs problems with the query optimizer, and it getting confused
and doing table scans instead of using indexes.
So far, we've solved the problem by doing a "set forceplan on" before the
query, and "set forceplan off" after the query. This forces Sybase to do
things in the order of the from clause, rather in its own order, and seems
to have solved the issue I was having. Maybe this could solve yours?
Mark
--On Tuesday, July 17, 2001 17:39:17 +1200 Mike Osborne
<[EMAIL PROTECTED]> wrote:
> I am working with a client that has recently upgraded from Sybase v11 to
> SyBase v12.
> (Yes - they are behind in their upgrades.)
> This upgrade has tripled server CPU usage and pushed response times out to
--
Vi de udødelige inviterer dere til å slå dere sammen med oss
---------------------------------------------------------------------------
New Zealand Delphi Users group - Offtopic List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe offtopic"
Web Archive at: http://www.mail-archive.com/offtopic%40delphi.org.nz/
