New statistics

Question

New statistics

Steve Jones - SSC Editor

SSC Guru

Points: 736418
More actions
July 9, 2019 at 12:00 am

#3658991

Comments posted to this topic are about the item New statistics

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Stewart "Arturius" Campbell SSC Guru Points: 72634 More actions · Answer 1

Good question, thanks Steve

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”

Uwe Ricken Hall of Fame Points: 3169 More actions · Answer 2

Hi Steve,

I trapped into the pitfall and didn't see that the last query was not using any predicate 🙂

If you use a query with a predicate it will create a statistics object automatically (in your scenario)

Microsoft Certified Master: SQL Server 2008
MVP - Data Platform (2013 - ...)
my blog: http://www.sqlmaster.de (german only!)

Rune Bivrin SSCrazy Eights Points: 8522 More actions · Answer 3

Hush! That's probably for an upcoming QotD...

Just because you're right doesn't mean everybody else is wrong.

dotathinker SSC Enthusiast Points: 133 More actions · Answer 4

Also if you have case sensitive collation, you spell ages with both uppercase letter and lowercase letter. That would also return 0 rows.

Steve Jones - SSC Editor SSC Guru Points: 736418 More actions · Answer 5

Good catch. I never run case sensitive, but edited the question.

TomThomson SSC Guru Points: 104773 More actions · Answer 6

The explanation is somewhat broken - it says that if you query the table you will generate stats data. Well, you did query the table, and you didn't generate any stats data. The explanation should say that to make stats data by querying the table you have to have some meaningful condition in your query.

But I didn't know that, so I've learnt something from the question anyway.

Tom