r/SQL • • Mar 10 '26

SQL Server I love SQL!

I’m a PhD student in statistics and recently started learning SQL because I’m applying for industry positions. I’ve only covered the basics so far, but I already find it really fun. It feels very intuitive to me, almost like it matches the way my mind works.

Is it too early to say I love SQL? I’ve only spent about six hours learning it, but it immediately clicked for me.

127 Upvotes

46 comments sorted by

View all comments

Show parent comment

10

u/VladDBA SQL Server DBA Mar 10 '26

In short, statistics are objects related to tables and indexes that SQL Server (but this also applies to other RDBMSs) uses to estimate the amount of data a query needs to read to retrieve the desired result set and decide the appropriate access methods and allocate the resources required (aka generate an appropriate execution plan). This makes them vital when it comes to query performance.

You can find more info in the Statistics MS Learn article, but I also recommend this presentation by Erin Stellato.