On Fri, 9 May 2003, Tom Lane wrote:
> >> Well, it is surely no better than the correlation of the index's
> >> first column --- what is that?
>
> > it is 1
>
> Well, that's suggestive, isn't it? What about the remaining columns?
The index is defined as:
status_all btree (assettable, assetidval, appname, apptblname, status,
isvalid)
And correlations are:
attname | correlation
-------------+-------------
assettable | 1
assetidval | 0.125902
appname | 0.942771
apptblname | 0.928761
status | 0.443405
isvalid | 0.970531
>
> regards, tom lane
>
--
==================================================================
Achilleus Mantzios
S/W Engineer
IT dept
Dynacom Tankers Mngmt
Nikis 4, Glyfada
Athens 16610
Greece
tel: +30-210-8981112
fax: +30-210-8981877
email: achill@matrix.gatewaynet.com
mantzios@softlab.ece.ntua.gr
