Hi, I have started using duckdb ui and i have question on the right side menu that is being displayed when a sql query is executed.
When I run a simple query select * from table, it quickly shows me all the relevant info for each column where it tells me the number of unique values for that column and for each column it shows the count of records for top 10 values in case of varchar column. So i would like to know if the count of unique that is being displayed next to the column name is an approximation or the exact value.
I've noticed that the value shown doesn't tie to the actual number in the table.
Hi, I have started using duckdb ui and i have question on the right side menu that is being displayed when a sql query is executed.
When I run a simple query select * from table, it quickly shows me all the relevant info for each column where it tells me the number of unique values for that column and for each column it shows the count of records for top 10 values in case of varchar column. So i would like to know if the count of unique that is being displayed next to the column name is an approximation or the exact value.
I've noticed that the value shown doesn't tie to the actual number in the table.