UPDATE STATISTICS
Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance
When I run UPDATE STATISTICS on an index I sometimes get this message
"Statistics on this index do not exist".
Is there any way I can check wether an index has statistics or not. I have
looked at the INFORMATION_SCHEMA.INDEXES view but havent found out how I can
retrive this information there.
Thore Berntsen
Visma Retail
.
Relevant Pages
- Re: How to capture SQL statement messages in DTS log file
... To capture the statistics date, look at the STATS_DATE function in the Books ... Then instead of PRINT in your DTS package, ... The execution of the following DTS Package succeeded: ... Update statistics for DYNAMICS User Tables ...
(microsoft.public.sqlserver.dts) - Re: Auto update statistics
... We recently solved a problem that was> sucking up proccessor cycles and limited the number of clients on a> database server. ... It is highly likely that there> are numerous inefficient queries. ... On view was that having this on would cause spikes in>>> utilization whenever the auto update kicks in during peak load time,>>> and so this option should be turned off and update statistics should>>> be run via a job during off times. ... running a bunch of inefficient queries will put more>> stress on the server than allowing SQL Server to update statistics as it ...
(microsoft.public.sqlserver.server) - Re: How to capture SQL statement messages in DTS log file
... To capture the statistics date, look at the STATS_DATE function in the Books ... I am rather new to SQL Server ... Then instead of PRINT in your DTS package, ... Update statistics for DYNAMICS User Tables ...
(microsoft.public.sqlserver.dts) - Re: update statistics
... I assumed this would be slow but avoid having the statistics updated by ... Repeat timings. ... Update statistics had no effect. ... the SE optimizer doesn't do a lot with statistics. ...
(comp.databases.informix) - RE: Query Help - Wrong Execution Plans
... My name is Michael and I would like to thank you for using Microsoft ... If I learned correctly that your query returned a large number of records ... statistics on indexed columns (as long as automatic query statistic ... we have to use UPDATE STATISTICS statement to update STATISTICS ...
(microsoft.public.sqlserver.server) |
|
