[ https://issues.apache.org/jira/browse/CALCITE-5943?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17756686#comment-17756686 ]
Jiajun Xie commented on CALCITE-5943: ------------------------------------- [~libenchao] No, this is discussion about `Selectivity`. I can't found anything about `Selectivity` in ANSI SQL 2011. Here is concept in Oracle: https://docs.oracle.com/cd/B10500_01/appdev.920/a96595/dci08opt.htm > RelMdSelectivity can return more precise selectivity for Sample > --------------------------------------------------------------- > > Key: CALCITE-5943 > URL: https://issues.apache.org/jira/browse/CALCITE-5943 > Project: Calcite > Issue Type: Improvement > Reporter: Jiajun Xie > Assignee: Jiajun Xie > Priority: Minor > > For the SQL > {code:java} > select * from emp tablesample bernoulli(50) {code} > selectivity is 1.0, maybe 0.5 will be better. > -- This message was sent by Atlassian Jira (v8.20.10#820010)