Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from Snowy on Oct 19 at 12:21 PM Hi, I do not know much about Sybase, but on other databases, I would use RUNSTATS on this table and see if that helps.
| | | ---------------Original Message--------------- From: supriyamhatre Sent: Friday, October 16, 2015 2:40 PM Subject: Sybase Query Running for a Long Time Hi, One query in production server takes 8 minutes to run. It has almost 32k records. query is select * from sapdslocal.ALVW_FLOW_STAT ALVW_FLOW_STAT is a view That same query I executed in quality and it runs withing few seconds. Any suggestions. Regards, Supriya | | Reply to this email to post your response. __.____._ | _.____.__ |