No announcements
Found 3511419 threads
-
6 Votesuse of update statistics?
when we use update statistics??Answered | 4 Replies | 4053 Views | Created by SaiKumar G - Thursday, June 21, 2012 3:45 PM | Last reply by SQLBAG - Saturday, June 23, 2012 9:28 AM
-
0 Votes
Update Statistics
Note that my testing show that sp_updatestats do not update statistics for the whole database.Answered | 9 Replies | 1848 Views | Created by VijayKSQL - Thursday, September 5, 2013 5:36 AM | Last reply by TiborK - Thursday, September 5, 2013 11:08 AM -
2 Votes
Update Statistics
Statistics should be updated periodically, but not before each run.Answered | 11 Replies | 4980 Views | Created by psingla - Wednesday, April 27, 2011 9:51 AM | Last reply by Eric Isaacs - Wednesday, April 27, 2011 10:45 PM -
0 Votes
Update statistics
It is recommended to stop Auto update statistics and run the update statistics weekely once during half peak hours.Answered | 4 Replies | 1184 Views | Created by Rakesh Talla - Monday, April 22, 2013 8:25 AM | Last reply by Kalman Toth - Monday, April 22, 2013 12:47 PM -
3 Votes
Update Statistics
Hi, If statistics are not updated, Will it wont fetch the datas?Answered | 9 Replies | 5712 Views | Created by Ranjith12 - Wednesday, February 9, 2011 1:49 PM | Last reply by SQLMojoe - Sunday, February 13, 2011 6:22 PM -
0 Votes
Update Statistics
http://www.benjaminnevarez.com/2010/07/rebuilding-indexes-vs-updating-statistics/Answered | 5 Replies | 595 Views | Created by adilrehman - Friday, July 20, 2018 5:02 AM | Last reply by Shanky_621 - Friday, July 20, 2018 7:39 AM -
0 Votes
Update statistics
You can running UPDATE STATISTICS on Wed...Answered | 2 Replies | 2360 Views | Created by Surya.chamala - Saturday, September 14, 2013 7:24 PM | Last reply by Uri Dimant - Monday, September 16, 2013 5:23 AM -
0 Votes
Update statistics
I wrote a custom script to update statistics more intelligently.Answered | 4 Replies | 1317 Views | Created by venkat83 - Monday, August 25, 2014 4:01 PM | Last reply by Satish Kartan, MCITP - Monday, August 25, 2014 5:01 PM -
0 Votes
Rebuild Indexing and Update Statistics
Yes, absolutley do not update statistics after rebuilding indexes.Answered | 11 Replies | 12604 Views | Created by Agha Ali - Tuesday, May 11, 2010 12:55 PM | Last reply by limssd - Wednesday, February 8, 2017 3:22 AM -
0 Votes
Update statistics
HI, How long the update statistics job used to run on the largest database(of size 1 TB)?Answered | 1 Replies | 1588 Views | Created by Surya.chamala - Saturday, September 14, 2013 7:18 PM | Last reply by Shanky_621 - Sunday, September 15, 2013 4:44 AM -
0 Votes
Update statistics
Varun, You can also use Ola hallengren index solution.Answered | 4 Replies | 894 Views | Created by Raje14 - Thursday, September 10, 2015 6:52 AM | Last reply by Shanky_621 - Thursday, September 10, 2015 8:38 AM -
1 Votes
Rebuild indexes and Update Statistics?
Instead, the query optimizer uses the default sampling algorithm to generate these statistics.Answered | 6 Replies | 14549 Views | Created by NguyenBL - Monday, April 23, 2012 9:07 PM | Last reply by mi-usuario - Friday, September 7, 2018 3:07 PM -
5 Votes
updating statistics on big tables
Or at the least use filtered statistics (but it depends on access pattern).Answered | 7 Replies | 6514 Views | Created by Samantha v - Friday, April 15, 2016 6:39 AM | Last reply by Andrea Caldarone - Tuesday, April 19, 2016 9:11 AM -
0 Votes
Auto Update Statistics not updating the stats
I presume, using recompile option would update stats as it will create a new plan.Answered | 8 Replies | 3215 Views | Created by Stan210 - Thursday, January 15, 2015 12:30 AM | Last reply by Stan210 - Tuesday, January 20, 2015 4:21 AM -
0 Votes
Create Statistics and Update Statistics command--Access Path
When statistics are created and updated, the optimizer must choose an access path to gather the statistics.Answered | 1 Replies | 904 Views | Created by LearnerSql - Thursday, June 26, 2014 11:46 PM | Last reply by RAJU RG - Friday, June 27, 2014 2:29 AM -
0 Votes
ALTER INDEX / UPDATE STATISTICS
Ok, so I'm just goin to do the ALTER INDEX and omit UPDATE STATISTICS statement because the alter does update the statistics.Answered | 9 Replies | 5179 Views | Created by amendez - Tuesday, March 3, 2009 2:16 PM | Last reply by TiborK - Tuesday, March 3, 2009 8:38 PM -
0 Votes
Auto Update statistics
Hi, How often auto update statistics run when it is on?Answered | 2 Replies | 1114 Views | Created by Surya.chamala - Thursday, February 20, 2014 9:00 PM | Last reply by Shanky_621 - Thursday, February 20, 2014 9:49 PM -
0 Votes
Auto Update Statistics
No, statistics are typically updated when SQL Server needs to run a query.Answered | 1 Replies | 2446 Views | Created by nadirsql - Tuesday, December 27, 2011 10:06 PM | Last reply by Erland Sommarskog - Tuesday, December 27, 2011 10:26 PM -
4 Votes
Frequency of Updating Statistics
Also, please suggest about the updating statistics for system databases -- Reddy Balaji C.Answered | 7 Replies | 5139 Views | Created by Reddy Balaji C - Monday, August 13, 2012 2:17 AM | Last reply by SQLZealots - Tuesday, August 14, 2012 10:28 AM -
2 Votes
Update Statistics blocks update queries?
So, you wouldn't be able to change a table's definition whilst UPDATE STATISTICS is running, for example.Answered | 2 Replies | 1886 Views | Created by Kalyan Chakravarthi (MCP) - Monday, August 19, 2013 12:57 PM | Last reply by Andrew Bainbridge - Monday, August 19, 2013 1:17 PM - Items 1 to 20 of 3511419 Next ›
No announcements
