Stats collection on tables without indexes
Hi All,
I was trying to see if I am able to omit generating stats on some of the very large staging tables that do not have any indexes.
I did see some posts that histograms on such tables(that do not have any indexes and so will always participate as FTS) will still be useful for determining the join order of tables. Even though I dont generate histograms, I still felt that the num_rows itself will be helpful in determining the table joining order. Without this info, there is potentially a possibility of a wrong join order. If this is correct, then I want to go ahead and generate for ALL tables irrespective of presence of indexes.
I was trying to see if I am able to omit generating stats on some of the very large staging tables that do not have any indexes.
I did see some posts that histograms on such tables(that do not have any indexes and so will always participate as FTS) will still be useful for determining the join order of tables. Even though I dont generate histograms, I still felt that the num_rows itself will be helpful in determining the table joining order. Without this info, there is potentially a possibility of a wrong join order. If this is correct, then I want to go ahead and generate for ALL tables irrespective of presence of indexes.
0