Known issue - SQL analytics endpoint tables lose statistics
After you successfully sync your tables in your SQL analytics endpoint, the statistics get dropped.
Status: Open
Product Experience: Data Warehouse
Symptoms
Statistics created on the SQL analytics endpoint tables aren't available after a successful sync between the lakehouse and the SQL analytics endpoint.
Solutions and workarounds
The behavior is currently expected for the tables after a schema change. You need to recreate the statistics or allow the auto statistics to run when necessary.