| /dports/finance/R-cran-PerformanceAnalytics/PerformanceAnalytics/man/ |
| H A D | NetSelectivity.Rd | 5 \title{Net selectivity of the return distribution}
20 Net selectivity is the remaining selectivity after deducting the amount of return
24 If net selectivity is negative the portfolio manager has not justified the loss of
27 \deqn{Net selectivity = \alpha - d}{Net selectivity = Selectity - diversification}
29 where \eqn{\alpha} is the selectivity and \eqn{d} is the diversification
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/sql/histograms/ |
| H A D | histogram.cc | 1425 *selectivity = in get_selectivity_dispatcher()
1433 *selectivity = apply_operator(op, value); in get_selectivity_dispatcher()
1652 *selectivity = std::max( in get_selectivity()
1673 *selectivity = std::max(0.0, *selectivity); in get_selectivity()
1695 *selectivity = 0.0; in get_selectivity()
1702 *selectivity += equals_to_selectivity; in get_selectivity()
1711 *selectivity = std::min(*selectivity, get_non_null_values_frequency()); in get_selectivity()
1722 *selectivity = 0.0; in get_selectivity()
1729 *selectivity -= equals_to_selectivity; in get_selectivity()
1730 if (*selectivity <= 0.0) break; in get_selectivity()
[all …]
|
| /dports/databases/postgis32/postgis-3.2.0/postgis/ |
| H A D | gserialized_estimate.c | 1067 float8 selectivity; in estimate_join_selectivity() local
1234 if ( isnan(selectivity) || ! isfinite(selectivity) || selectivity < 0.0 ) in estimate_join_selectivity()
1240 selectivity = 1.0; in estimate_join_selectivity()
1243 return selectivity; in estimate_join_selectivity()
1279 float8 selectivity; in gserialized_joinsel_internal() local
1321 return selectivity; in gserialized_joinsel_internal()
1961 float8 selectivity; in estimate_selectivity() local
2069 if (selectivity > 1.0) selectivity = 1.0; in estimate_selectivity()
2070 else if (selectivity < 0.0) selectivity = 0.0; in estimate_selectivity()
2072 return selectivity; in estimate_selectivity()
[all …]
|
| H A D | gserialized_supportfn.c | 294 req->selectivity = gserialized_joinsel_internal(req->root, req->args, req->jointype, 2); in postgis_index_supportfn()
298 req->selectivity = gserialized_sel_internal(req->root, req->args, req->varRelid, 2); in postgis_index_supportfn()
300 POSTGIS_DEBUGF(2, "%s: got selectivity %g", __func__, req->selectivity); in postgis_index_supportfn()
|
| /dports/databases/postgis31/postgis-3.1.4/postgis/ |
| H A D | gserialized_estimate.c | 1067 float8 selectivity; in estimate_join_selectivity() local
1234 if ( isnan(selectivity) || ! isfinite(selectivity) || selectivity < 0.0 ) in estimate_join_selectivity()
1240 selectivity = 1.0; in estimate_join_selectivity()
1243 return selectivity; in estimate_join_selectivity()
1279 float8 selectivity; in gserialized_joinsel_internal() local
1321 return selectivity; in gserialized_joinsel_internal()
1957 float8 selectivity; in estimate_selectivity() local
2065 if (selectivity > 1.0) selectivity = 1.0; in estimate_selectivity()
2066 else if (selectivity < 0.0) selectivity = 0.0; in estimate_selectivity()
2068 return selectivity; in estimate_selectivity()
[all …]
|
| H A D | gserialized_supportfn.c | 294 req->selectivity = gserialized_joinsel_internal(req->root, req->args, req->jointype, 2); in postgis_index_supportfn()
298 req->selectivity = gserialized_sel_internal(req->root, req->args, req->varRelid, 2); in postgis_index_supportfn()
300 POSTGIS_DEBUGF(2, "%s: got selectivity %g", __func__, req->selectivity); in postgis_index_supportfn()
|
| /dports/databases/postgis30/postgis-3.0.4/postgis/ |
| H A D | gserialized_estimate.c | 1050 float8 selectivity; in estimate_join_selectivity() local
1217 if ( isnan(selectivity) || ! isfinite(selectivity) || selectivity < 0.0 ) in estimate_join_selectivity()
1223 selectivity = 1.0; in estimate_join_selectivity()
1226 return selectivity; in estimate_join_selectivity()
1262 float8 selectivity; in gserialized_joinsel_internal() local
1304 return selectivity; in gserialized_joinsel_internal()
1951 float8 selectivity; in estimate_selectivity() local
2059 if (selectivity > 1.0) selectivity = 1.0; in estimate_selectivity()
2060 else if (selectivity < 0.0) selectivity = 0.0; in estimate_selectivity()
2062 return selectivity; in estimate_selectivity()
[all …]
|
| H A D | gserialized_supportfn.c | 294 req->selectivity = gserialized_joinsel_internal(req->root, req->args, req->jointype, 2); in postgis_index_supportfn()
298 req->selectivity = gserialized_sel_internal(req->root, req->args, req->varRelid, 2); in postgis_index_supportfn()
300 POSTGIS_DEBUGF(2, "%s: got selectivity %g", __func__, req->selectivity); in postgis_index_supportfn()
|
| /dports/databases/postgis25/postgis-2.5.5/postgis/ |
| H A D | gserialized_estimate.c | 1058 float8 selectivity; in estimate_join_selectivity() local
1225 if ( isnan(selectivity) || ! isfinite(selectivity) || selectivity < 0.0 ) in estimate_join_selectivity()
1231 selectivity = 1.0; in estimate_join_selectivity()
1234 return selectivity; in estimate_join_selectivity()
1289 float8 selectivity; in gserialized_gist_joinsel() local
1940 float8 selectivity; in estimate_selectivity() local
2048 if (selectivity > 1.0) selectivity = 1.0; in estimate_selectivity()
2049 else if (selectivity < 0.0) selectivity = 0.0; in estimate_selectivity()
2051 return selectivity; in estimate_selectivity()
2100 float8 selectivity = 0; in _postgis_gserialized_sel() local
[all …]
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/secondary_engine/t/ |
| H A D | histogram.test | 17 # Without histograms, all three queries get the same selectivity (10%).
23 # With histograms, the selectivity varies with the constant used in
42 # Recreate the histogram and get the good selectivity estimates back.
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/opt_trace/t/ |
| H A D | histograms.test | 72 --echo # Show the difference between the calculated selectivity estimation for
73 --echo # each predicate and the total calculated selectivity estimation
85 --echo # Total calculated selectivity estimation.
|
| /dports/textproc/p5-CSS-Simple/CSS-Simple-3220/ |
| H A D | README | 104 Modifying a selector maintains the existing selectivity of the rule
106 selectivity, delete the element and re-add it to CSS::Simple
120 existing selectivity will continue to persist. Delete the selector
121 first if you want to ignore the previous selectivity.
130 Add properties to an existing selector, preserving the selectivity
|
| /dports/databases/xtrabackup8/percona-xtrabackup-8.0.14/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 81 #EQ-range selectivity depends on
85 # - min 2% selectivity
88 # above which further improves selectivity
|
| /dports/databases/percona56-server/percona-server-5.6.51-91.0/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 87 #EQ-range selectivity depends on
91 # - min 2% selectivity
94 # above which further improves selectivity
|
| /dports/databases/percona56-client/percona-server-5.6.51-91.0/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 87 #EQ-range selectivity depends on
91 # - min 2% selectivity
94 # above which further improves selectivity
|
| /dports/databases/percona57-server/percona-server-5.7.36-39/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/percona57-pam-for-mysql/percona-server-5.7.36-39/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/percona-pam-for-mysql/percona-server-5.6.51-91.0/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 87 #EQ-range selectivity depends on
91 # - min 2% selectivity
94 # above which further improves selectivity
|
| /dports/databases/mysqlwsrep57-server/mysql-wsrep-wsrep_5.7.35-25.27/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/xtrabackup/percona-xtrabackup-2.4.21/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/percona57-client/percona-server-5.7.36-39/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/mysqlwsrep56-server/mysql-wsrep-wsrep_5.6.51-25.33/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 87 #EQ-range selectivity depends on
91 # - min 2% selectivity
94 # above which further improves selectivity
|
| /dports/databases/mysql57-client/mysql-5.7.36/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 85 #EQ-range selectivity depends on
89 # - min 2% selectivity
92 # above which further improves selectivity
|
| /dports/databases/mysql56-client/mysql-5.6.51/mysql-test/suite/ndb/t/ |
| H A D | ndb_statistics.inc | 87 #EQ-range selectivity depends on
91 # - min 2% selectivity
94 # above which further improves selectivity
|
| /dports/databases/mariadb105-client/mariadb-10.5.15/mysql-test/main/ |
| H A D | selectivity_no_engine.test | 5 --echo # Engine-agnostic tests for statistics-based selectivity calculations.
6 --echo # - selectivity tests that depend on the engine should go into
7 --echo # t/selectivity.test. That test is run with myisam/innodb/xtradb.
107 --echo # MDEV-5980: EITS: if condition is used for REF access, its selectivity is still in filtered%
195 --echo # MDEV-5985: EITS: selectivity estimates look illogical for join and non-key equalities
|