November 10, 2009 at 2:17 pm
The Subject says the core of it. I have a table that is dropped and recreated each night, it is an aggregate of daily data with an "as of date" type thing.
I was running the DTA to help tune some SP's that are bounced off of this table, and it naturally recommends a few of it's _dta_stat_ recommendations.
In my understanding Statistics are managed for data that changes within a column is it not? So data that is static and recreated fresh each day, creating a statistic on this would be pointless?
Link to my blog http://notyelf.com/
November 11, 2009 at 7:38 am
If you are querying the table then the optimizer needs statistics to choose the best access plan. Typically you have autocreate statistics on so the stats should be created anyway.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 11, 2009 at 9:50 am
Yes Autocreate Statistics are on. I was just making sure the DTA tuning engine creating its own extra ones, if I should add that to the table drop and create process. Sounds like that would yield no more performance though 😀
Link to my blog http://notyelf.com/
November 11, 2009 at 9:58 am
You can't always trust all that DTA suggests. I'd be careful. If you are creating indexes and you have no complaints about performance I'd stay with what you've got. I'd also look at sys.dm_db_missing_index% views to see if maybe there are some indexes you should try.
Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question
November 11, 2009 at 10:12 am
I'll second Jack on the DTA. DTA isn't always accurate in the suggested indexes/statistics that it suggests.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply