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: 11-24-2014, 04:51 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
trade_id,
deal_id,
maturity_date,
product,
columna,
columb
from
problemtable a,
term b,
product_classification c
where
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
where
a.trade_id=d.trade_id)

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 1,190 07-05-2014 12:26 AM
Last Post: krishna.tadepalli5@gmail.com
  AseMon - GUI: Performance Monitor Tool for ASE goran_schwarz 2 6,035 05-06-2014 11:38 PM
Last Post: maheshvasn
  Learning Performance Tuning vinayp83 3 1,940 07-22-2013 05:44 PM
Last Post: tsadmin
  lock issue ashutosh_blr2378 3 1,986 02-07-2013 10:45 AM
Last Post: acid786
  database performance problem rozihan 5 3,296 02-02-2013 09:14 PM
Last Post: reshma.chawla0112
  Query Plans dicomal 1 2,158 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,286 01-14-2013 11:19 AM
Last Post: Bharathvajan
  problem with numeric datatype and related performance issue VenkataSai 0 2,274 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 3,922 07-22-2012 08:46 AM
Last Post: sarosh
  How to improve create non-clustered index performance taker2001 14 7,801 04-30-2012 04:38 AM
Last Post: taker2001

Options:
Forum Jump:


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