No announcements
Found 564452 threads
-
2 VotesHow to add statistics to a column
Then created a statistic on the same table and column.Answered | 9 Replies | 1281 Views | Created by TheBrenda - Wednesday, October 25, 2017 9:14 PM | Last reply by Will_Kong - Tuesday, October 31, 2017 10:20 AM
-
0 Votes
index and column statistics
Missing statistics are indicated as warnings (table name in red text) when the execution plan of a query is graphically displayed using SQL Server Management ...Answered | 6 Replies | 5768 Views | Created by Ryan_XH - Friday, June 3, 2011 6:55 PM | Last reply by Arbi Baghdanian - Friday, June 3, 2011 7:40 PM -
0 Votes
Statistics on non indexed columns
This will help you if you decide you need to create an index to replace the statistics, because you will need to know which columns to create the statistics on.Answered | 4 Replies | 6728 Views | Created by Mr Shaw - Tuesday, May 3, 2011 9:49 AM | Last reply by SQL_Jay - Tuesday, May 3, 2011 8:23 PM -
1 Votes
Multiple statistics on the same column
This is puzzling, that SQL server will use 2 statistics to determine the cardinality on that column predicate.Answered | 6 Replies | 2360 Views | Created by Dmitry Otblesk - Friday, October 4, 2013 3:02 AM | Last reply by Dmitry Otblesk - Monday, October 7, 2013 3:53 PM -
1 Votes
Missing column statistics from default trace
You might find the information in this older post ...Answered | 3 Replies | 12616 Views | Created by MrFlinstone - Friday, September 17, 2010 9:46 AM | Last reply by Jonathan Kehayias - Wednesday, September 22, 2010 2:41 AM -
3 Votes
Update Statistics
When I check the Execution plan, it shows the warning that the STATISTICS are not available for column (say three columns).Answered | 9 Replies | 5823 Views | Created by Ranjith12 - Wednesday, February 9, 2011 1:49 PM | Last reply by SQLMojoe - Sunday, February 13, 2011 6:22 PM -
2 Votes
auto create statistics
How Automatic Statistics Work When you create an index, the query optimizer automatically stores statistical information about the indexed ...Answered | 2 Replies | 9553 Views | Created by ronald_yoh - Wednesday, September 15, 2010 5:39 AM | Last reply by Uri Dimant - Wednesday, September 15, 2010 7:27 AM -
1 Votes
Statistics myth?
(let me rephrase it... is there any valid reason to update statistics of columns not participating in any index?Answered | 10 Replies | 972 Views | Created by maca128 - Thursday, May 14, 2015 3:19 PM | Last reply by Erland Sommarskog - Friday, May 15, 2015 7:12 AM -
1 Votes
Statistics for optimization
Auto create statistics only create statistics on index key columns or sinle-columns predicates.Answered | 3 Replies | 1957 Views | Created by skc_chat - Friday, September 7, 2012 6:05 AM | Last reply by Rishabh K - Friday, September 7, 2012 6:44 AM -
0 Votes
Orphaned Statistics
Staistics is updated on a threshold basis (hom many times a column is modified; you can get from sysindexes) you cant say statistics object is not ...Answered | 6 Replies | 2983 Views | Created by warnerrj79 - Friday, February 8, 2013 4:38 PM | Last reply by SathyanarrayananS - Saturday, February 9, 2013 5:36 AM -
0 Votes
Update statistics
I wrote a custom script to update statistics more intelligently.Answered | 4 Replies | 1461 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
Statistics
In most cases statistics that is based on a sample is good enough (it might be a case if you have an extremely unbalanced data distribution - in this case the UPDATE ...Answered | 3 Replies | 1223 Views | Created by bills1988 - Saturday, December 12, 2015 9:22 AM | Last reply by Uri Dimant - Tuesday, December 15, 2015 6:53 AM -
1 Votes
statistics
You'd want to chose "column statistics only" if you first did rebuild.Answered | 1 Replies | 1970 Views | Created by Manu_vmr - Thursday, November 1, 2012 1:13 PM | Last reply by TiborK - Thursday, November 1, 2012 1:18 PM -
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 | 1000 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
Update Statistics
You have had to do 2,000,000 modifications for the column(s) in order for sp_updatestats to update the statistics.Answered | 9 Replies | 1981 Views | Created by VijayKSQL - Thursday, September 5, 2013 5:36 AM | Last reply by TiborK - Thursday, September 5, 2013 11:08 AM -
2 Votes
statistics
Hi naga Statistics : it is defined as detail about table like no.of records , available indexes , page density.Answered | 6 Replies | 1559 Views | Created by SLNSH - Thursday, March 14, 2013 1:19 PM | Last reply by Saurabh Sinha DBA - Thursday, March 14, 2013 7:03 PM -
0 Votes
Update statistics
You can running UPDATE STATISTICS on Wed...Answered | 2 Replies | 2501 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
Alert on AUTO CREATE STATISTICS
But the auto create of statistics is not done because you ran a DDL command.Answered | 2 Replies | 2376 Views | Created by Dave Turpin - Tuesday, July 2, 2013 5:20 PM | Last reply by Dave Turpin - Wednesday, July 3, 2013 2:21 PM -
0 Votes
Indexes showing up as statistics??
only entries marked as statistics.Answered | 5 Replies | 887 Views | Created by John Couch - Wednesday, July 15, 2015 7:30 PM | Last reply by John Couch - Thursday, July 16, 2015 11:35 AM -
1 Votes
Where is the statistics stored
Microsoft SQL Server 2008 collects statistics about individual columns (single-column statistics) or sets of columns (multicolumn ...Answered | 2 Replies | 7885 Views | Created by Ola Hallengren - Saturday, November 27, 2010 3:23 PM | Last reply by TiborK - Monday, November 29, 2010 12:40 PM - Items 1 to 20 of 564452 Next ›
No announcements
