Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Christina Agyeman
Starting Member
15 Posts |
 Posted - 2002-06-13 : 09:24:51
|
| Does SQL Server automatically create column statistics for indexed columns. If so will it appear in the Manage Statistics dialog in Query Analyzer. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-06-13 : 09:36:23
|
| There is an auto create statistics setting. If you choose the Properties for the database in Enterprise Manager you'll find the checkbox for it. You can also set it using sp_dboption (see Books Online for more info)I'm not sure how that would affect the Query Analyzer tool as I've never used it before, but I imagine any statistics that exist in the database should appear in that window. |
 |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-06-13 : 16:21:34
|
| Actually, even with the "autocreate statistics" option turned off, SQL Server will keep statistics on the indexed columns. AFAIK, those statistics aren't supposed to appear in the Manage Statistics tool. SQL Server will manage them automatically as needed(unless you created your index using STATISTICS_NORECOMPUTE option, in which case you will need to run UPDATE STATISTICS command to bring them up-to-date). |
|
|
|
|
|
|
Column Statistics