]
Cc: pgsql-admin
Subject: Re: [ADMIN] Are statistics gathered on function indexes?
Nick Fankhauser [EMAIL PROTECTED] writes:
[see subject]
Nope, they ain't. I agree they should be.
Can someone tell me how the cost is estimated for retrieving a
column based
on a function that is indexed
: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
Sent: Wednesday, June 26, 2002 10:37 PM
To: [EMAIL PROTECTED]
Cc: pgsql-admin
Subject: Re: [ADMIN] Are statistics gathered on function indexes?
Nick Fankhauser [EMAIL PROTECTED] writes:
[see subject]
Nope
Hi-
Can someone tell me how the cost is estimated for retrieving a column based
on a function that is indexed?
The issue I'm wrestling with is a query which works nicely when based on a
plain LIKE field, butpoorly using LIKE upper(field). There is an
index on both.
Since this field has