Describe the problem

I joined three tables into a materialized view in my database, but I am not observing any auto-statistic creation jobs running on the view, nor am I able to manual create the statistics, instead receiving the following error:

root@test-db:26257/test> analyze test_view_v0_0;
ERROR: "test_view_v0_0" is not a table
SQLSTATE: 42809

To Reproduce

1. Create two tables
2. Create view from both tables, no functions used, just denormalizing the data
3. Create a few non-covering indexes on the view also.
4. Observe that stats are not created, nor can you manually run Analyze or CREATE STATISTICS

Expected behavior
I would expect to be able to generate statistics on a materialized view and it's indices.

Environment:

• CockroachDB version 21.2.5

Additional context
Attempting to optimize queries on an extremely large dataset are not using the intended indexes due to lack of statistics

Jira issue: CRDB-14007
Epic: CRDB-13625