Great !! Your explanation was very good. Now I have tables in the Synapse Pool that need statistics, a video recommending the correct execution of the statistics in tables would be very good.
Thanks for taking out time and providing such a insightful details about indexing !! Any thoughts at 40:00 - how can someone identify if particular rowgroup is softdeleted ? and why so 2 RowGroup/Distribution during ingestion & 1 RowGroup/Distribution during update ? is there any pattern or logic behind it ?