Index statistics update with full scan.

Question

Index statistics update with full scan.

paras.gtr990

SSC Rookie

Points: 42
More actions
March 22, 2018 at 6:28 am

#327997

Can anyone help me to sort this out , Does updating index statistics with full scan rebuilds the index ?

Viewing 4 posts - 1 through 3 (of 3 total)

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

NorthernSoul SSCertifiable Points: 6869 More actions · Answer 1

paras.gtr990 - Thursday, March 22, 2018 6:28 AM
Can anyone help me to sort this out , Does updating index statistics with full scan rebuilds the index ?

No it doesn't rebuild the index. The usual sequence is to perform index maintenance then update the statistics.

Thanks

Perry Whittle SSC Guru Points: 234013 More actions · Answer 2

paras.gtr990 - Thursday, March 22, 2018 6:28 AM
Can anyone help me to sort this out , Does updating index statistics with full scan rebuilds the index ?

Other way around, rebuilding the index rebuilds the stats with a full scan

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

Jeff Moden SSC Guru Points: 1004414 More actions · Answer 3

Don't forget about "Column Statistics", which aren't ever updated by rebuilding an index. Also don't forget that reorganizing an index will do nothing for any statistics.

Last but not least, don't forget that it's totally unnecessary to rebuild index statistics on indexes that have been rebuilt.

--Jeff Moden

RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

Change is inevitable... Change for the better is not.

Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)