You are not logged in or registered. Please login or register to use the full functionality of this Website SybaseTeam.Com...
Hello There, Guest! (LoginRegister) Remember Me? Current time: 04-27-2015, 09:01 AM
   Home  |  About Us  |  Sybase Training  |  Synergy  |  Consulting  |  Job Openings  |  Tech Videos  |  Rules and Disclaimer  |  Search
Post Reply 
Forum Tools
Query performance issue after upgrade help needed
01-11-2012, 05:43 PM
Post: #1
Quote this message in a reply
Query performance issue after upgrade help needed

Hi All,
I am experiencing a performance issue for a batch process after migration on ASE 15.5 from 12.5. The batch process used to take just 4 mins on ASE 12.5, now it hangs up for 3 days. The batch process does execute few query very fast but as soon as it come across one of the table, it get hang. But after creating an index on the table the batch moves ahead. I don't understand why should I create an index on the table if the batch works fine without index on 12.5. I also tried using different optimization goals, force plan on, merge_join off,update statistics but it didn't help me. The query looks like something as below :

Select Distinct
problemtable a,
term b,
product_classification c
a.term_id=b.term_id and
a.product_id=c.product_id and
/* the below sub query is problematic, on creating index on trade_id, it run fast */
convert(datetime,maturity_date) in ( select max(convert(datetime,maturity_date)) from problemtable d

Please suggest

Find all posts by this user
Post Reply 

Possibly Related Threads...
Thread: Author Replies: Views: Last Post
  How to Optimize Sybase Union query sureshk_85 1 2,082 07-05-2014 12:26 AM
Last Post:
  AseMon - GUI: Performance Monitor Tool for ASE goran_schwarz 2 6,720 05-06-2014 11:38 PM
Last Post: maheshvasn
  Learning Performance Tuning vinayp83 3 2,328 07-22-2013 05:44 PM
Last Post: tsadmin
  lock issue ashutosh_blr2378 3 2,213 02-07-2013 10:45 AM
Last Post: acid786
  database performance problem rozihan 5 3,700 02-02-2013 09:14 PM
Last Post: reshma.chawla0112
  Query Plans dicomal 1 2,401 01-14-2013 11:21 PM
Last Post: tsadmin
  SQL (sybase) query using TOP N performs very badly when inserted into table tmatharu 2 2,613 01-14-2013 11:19 AM
Last Post: Bharathvajan
  problem with numeric datatype and related performance issue VenkataSai 0 2,574 08-03-2012 08:41 AM
Last Post: VenkataSai
  Query taking 30 hours after upgrading the server to 15.0 from 12.5 preetha16 11 4,371 07-22-2012 08:46 AM
Last Post: sarosh
  How to improve create non-clustered index performance taker2001 14 8,658 04-30-2012 04:38 AM
Last Post: taker2001

Forum Jump:

Contact Us | SybaseTeam | Disclaimer & Rules | Return to Top | Return to Content | Lite (Archive) Mode | RSS Syndication