Increased query time with release 12

[pjb]

We have recently gone to Sybase release 12 and are now experiencing and increase in time for queries to return. For example, the query:

select ship_date from table_a where (ship_date >= '07/01/02'
and ship_date < '08/01/02')

would take about 20 seconds with the previouse release, now takes about four minutes. We have contacted Sybase help, and the are clueless.

 

[JMCraig]

One little known recommendation (perhaps even at Sybase) is that it is suggested that you rebuild indexes when going to version 12 (at least I don't think I'm making this up). I'm assuming that your table has ship_date as the first element of some index. If this is the case, certainly try rebuilding the index (or if that takes a huge amount of time and you want to try something slightly faster, update the statistics on the table's indexes).

If that doesn't help, there are some other things you might try. A bit of info that would be helpful in troubleshooting this is the query plan. What does it show? An unindexed table scan perhaps? Can you post it for us?

BOL,

John J M Craig
Alpha-G Consulting, LLC

http://alphagconsulting.bizhosting.com

nsjmcraig@netscape.net