I have created several tables and populated very few records (like 5 to 10 rows) in each table.
But my metadata table INFORMATION_SCHEMA.TABLE_STATISTICS not showing the values properly.
I have executed ANALYZE command on these tables but no luck.
Still the table is showing the number of rows as zero only. Please let us know how to rectify it.