date of last update stats & sp_recompile

How would I check to see when update statistics for a table and sp_recompile
on a table was last run?
Preferably by means of isql.

2/15/2001 3:25:40 PM
sybase.sqlserver.performance 1181 articles. 0 followers. Follow

1 Replies

Similar Articles

[PageSpeed] 10

 select moddate from sysstatistics where id = object_id("<table name>")

You know, this doesn't work in 11.5 or lower version, only for 11.9.2 or


Simo wrote:

> Hi,
> How would I check to see when update statistics for a table and sp_recompile
> on a table was last run?
> Preferably by means of isql.
> Thanks.

2/15/2001 4:47:59 PM

Similar Artilces:

How do you know the last date/time update stats is run on a table?
regards, Abel The nitty-gritty is in sysstatistics. An SP that generates the output below is my sp_newstats proc in the dba.sql file at However you better read the Installation Guide first since other procs also have to be loaded. A quicker way would be to use the code and strip off the execution of sp_date, etc. that prettyprints the dates. sp_newstats CURRENT DATE/TIME -------------------------------- May 6, 2001 (08:40:53 AM) THERE ARE 48 STATISTICS ROWS FOR 9 SYSTEM TABLES IN systatistics. THERE ARE 4...

Update stats vs. update all stats
Under 11.9.2 update all stats will build stats for all columns, even those not used in an index, providing more information to the optimizer. It seems like we would always want to run update stats with the all option so that the optimizer has more information to work with. Is this valid ?? I am wondering if I should change my update stats jobs to use the all option. Any experiences or suggestions would be appreciated. Thanks Jerry Horochowianka Jerry Horochowianka wrote: > > Under 11.9.2 update all stats will build stats for all columns, even those > not used in...

Free Online Dating For You - Love & Dating
Hi Must visit these sites! http://free-online-da...

superreview canceled: [Bug 88454] add automatic "last update time" & update whole tree : [Attachment 117305] diffs against brad-fast tinderbox to add few fixes from bbaetz
Serge Gautherie <> has canceled superreview: Bug 88454: add automatic "last update time" & update whole tree Attachment 117305: diffs against brad-fast tinderbox to add few fixes from bbaetz ...

Last Date Updated
I am looking for a module which should show the last date the site was updated. I tried to find old topics related with this issue but the results were unrelated.. I am using DNN212. Can anyone help? I guess this module is in the WANTED list by a lot of ppl... Thank you for your help! [/antonisc] nobody? i thought it was an interesting topic but.. It is an interesting topic, but the challenge lies in figuring out what updated means in the context of any number of modules. It would require a standard way for all modules to notify the core when their content has been modifi...

Last Update Date?
Hi, Upon migrating PB 6.5 to PB 8, it seems the Last Update Date is set to today's date for all functions, windows and user objects. Datawindows are OK. Any suggestions? TIA This has been true since of migrations for all versions since Last Update Date was introduced. Not much you can do about it, except maybe document what it was before you migrated. (I know of a tool that will give you an easy printout of your object list, including the Last Update Date <g>. See below.) Good luck, Terry [TeamSybase] and Sequel the techno-kitten On Thu, 18 Oct 2001 17:07:2...

Update Stats Performance
I have recently built a replacement v 12.0 ASE Server for a production system and have found that on one particular database the update stats run(indexes only) is now taking approx 22hr to run whereas it takes 3.5 hrs. on existing system. The config of the 2 Sybase Servers are v. similar except for EBF level, new server is on 10456 old server is on 9625. The database in question is 10Gb in size and has 3 v.large archive tables. The only difference in config is that memory on new server is substantially higher and also had to change setting ofr open objects & open indexe...

Last updated date
Is there a way to find the date a table was updated. I can't find anything in the documentation. Thank you. Do you mean when the structure was updated or the data? There is nothing to support the former and the latter would require you to include an audit column of type DATETIME that is updated on each insert or update. -- Jim Egan [TeamSybase] Houston, TX Sybase Developers Network This is interesting, Jim. There really isn't any statistic maintained on when a table was created or structurally changed. This was on purpo...

Last Updated Date
Does anyone know of existing code that can get the last date the page/tab/modules was updated? Daniel StruveDotNetNuke Houston nice addition ... currently the tab table doesn't have any created, ammended dates... anyone done this?Visit - index of DNN threads - hand picked quality threads. TextLayout Module - create multiple column layouts easily yea, Im have to customize dnn more and more. Im getting worried with the new version coming outDaniel StruveDotNetNuke Houston I would be willing to do this, I wonder if someone with more exposure to tab settings could su...

Last Contact Date Not Updating
I have three workstations where their last contact date is a few weeks ago, essentially when they were rolled out to the enduser. However, their last full refresh date is current; their systems were scanned by the inventory module and last uploaded has the correct dates and times. I'm just wondering why their last contact date is so far behind. I know that if I don't reboot my system daily, the contact date falls behind--for example, I haven't rebooted since 6/16, so my last contact date is 6/16. But in this case these machines -are- logged off and shut down every nigh...

Page last updated date
Can anyone tell me how to dynamically add a page last updated date to my page footer which is in a master page ? Thanks!  This article may provide you with direction "If you make it idiot proof, they'll build a better idiot" Thankyou!The link you provided along with information from provided exactly the solution I needed. Regards,David.  HiThe link provided by others will work only on static page. But for pages were the data is loaded ...

Indexes & update stats
All, I understand the table & index stats need to be regularly updated. Is there a need to run "update statistics" right after creating a new index? Is the stats updated automatically when a new index is created? eg: 1. Created a new table, table1 2. Created an index on the new table 3. Do I need to run update statistics table1 ????????? TIA, "Cecee Green" <> wrote in message news:1YH$ > All, > > I understand the table & index stats need to be regularly ...

index stats & sp_recompile
I happen to come across this, and was curious. I can see updating the DB statistics to reflect proper index retrieval. However, what is the "sp_recompile" function doing ? How would a stored procedure have "compile time" access to the array of index statistics ? Phil - sp_recompile is flagging the sproc, telling the server to recompile the query plan next time it is executed. Query plans are stored in sysprocedures, the source code in syscomments. When a sproc is compiled, it uses the current stats to create the query plan. If the stats become outda...

Date Site Last Updated
Does anyone have a module that will display the date a DNN site was last updated?JimMS MVP ASP.NET [VC++/MFC emeritus]Old Dog Learns New TricksPreferred programming language: cuneiform on clay tablets Jim, That certainly would be a nice module, but don't see how that would be possible, unless every module included field for 'LastUpdateDateTime'.  Not all modules have anthing like that info. Hey Jim,Take a look hereDave Thanks Dave, that looks like a useful module, but not quite what I had in mind.JimMS MVP ASP.NET [VC++/MFC emeritus]Old Dog Learns New TricksPreferred programming ...

Web resources about - date of last update stats & sp_recompile - sybase.sqlserver.performance

EXEC sp_updatestats EXEC sp_recompile N'schema.yourProcedure'; -
PASTEBIN - #1 paste tool since 2002 create new paste shop new! tools api archive faq PASTEBIN create new paste trending pastes sign up login ...

Resources last updated: 11/27/2015 2:53:31 PM