Magento2 reindexing

I want to know how reindexing works in Magento2. I am wondering what affects in my database when we do reindexing in Magento2.

Can anyone help me in this please

Thank you