+1Hi ,
I'm collecting statistics on the column and the whole table, but it is not reflected in the projections and projection_columns table.
Tried executing analyze_statistics with 100%, but still couldn't see it in system tables.
Please let me know if I'm missing anything.
+1Got the answer, it is because the table was full refreshed after the stats was collected. So a table with 0 columns won't collect any stats.
I hope my assumption is correct.
+1Thank you.
One more doubt. I have collected stats on the tables and columns with which I join the two tables.
But in the explain plan it shows NO STATISTICS.
Already have an account? Login
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
