Thanks a lot Arjun !

You explain me what exactly statisc is and what the sql server doing during update statics. Can you pls clear my more doubts?

1. Is it using indexing and sorting for this process ?

2. Is it using TempDB for data collection (for static purpose) ?

Thnx in advance,

Jitendra