Automated Stats gather on schema is not gathering Index stats
Hi. We have automated stats gather on the schema in a database. This job runs everyday. when i check last_analysed date for tables in the schema, it has has the date of the last run of the automated job. But the indexes on the tables have this date as 1st of the month when monthly gather stats run. the only difference between daily and monthly is that monthly deletes the stats and gather new ones, but daily just gathers the stats.