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-23-2014, 07:04 PM
   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 0 38 Yesterday 10:31 AM
Last Post: sureshk_85
  Learning Performance Tuning vinayp83 3 1,482 07-22-2013 05:44 PM
Last Post: tsadmin
  lock issue ashutosh_blr2378 3 1,627 02-07-2013 10:45 AM
Last Post: acid786
  database performance problem rozihan 5 2,450 02-02-2013 09:14 PM
Last Post: reshma.chawla0112
  Query Plans dicomal 1 1,723 01-14-2013 11:21 PM
Last Post: tsadmin
  SQL (sybase) query using TOP N performs very badly when inserted into table tmatharu 2 1,811 01-14-2013 11:19 AM
Last Post: Bharathvajan
  problem with numeric datatype and related performance issue VenkataSai 0 1,819 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,311 07-22-2012 08:46 AM
Last Post: sarosh
  How to improve create non-clustered index performance taker2001 14 6,343 04-30-2012 04:38 AM
Last Post: taker2001
  Making sense of query performance inarius 1 2,048 04-15-2012 05:28 PM
Last Post: DerekAsirvadem

Options:
Forum Jump:


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