Announcement:
wanna exchange links? contact me at sapchatroom@gmail.com.
Posted by
Admin at
Reply from supriyamhatre on Oct 19 at 2:36 PM Thank you Snowy, runstats worked. Now its running within few seconds.
This is what I executed.
sp_depends 'sapdslocal.ALVW_FLOW_STAT' (to find out base tables)
update statistics sapdslocal.AL_HISTORY (this is a base table)
| | | ---------------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. __.____._ |  _.____.__ |
