From: "Stephan Szabo" <[EMAIL PROTECTED]>
> You need to have made the database in C locale in order to get index scans
> from LIKE. I think that's mentioned in the Localization section of the
> admin guide, but I could be remembering that wrong.
Thanks very much Stephan. Indeed it's in Admin G
On Sat, 13 Jul 2002, Julian Scarfe wrote:
> From: "Stephan Szabo" <[EMAIL PROTECTED]>
>
> > You need to have made the database in C locale in order to get index scans
> > from LIKE. I think that's mentioned in the Localization section of the
> > admin guide, but I could be remembering that wrong
On Sat, 13 Jul 2002, Julian Scarfe wrote:
> I've noticed a difference in behaviour between a server running version 6.x
> and one running 7.2.1 in use of indexes with LIKE.
>
> With an index on foo,
>
> WHERE foo LIKE 'bar%'
>
> uses the index (as I would expect it to) on the 6.x box, but uses a
I've noticed a difference in behaviour between a server running version 6.x
and one running 7.2.1 in use of indexes with LIKE.
With an index on foo,
WHERE foo LIKE 'bar%'
uses the index (as I would expect it to) on the 6.x box, but uses a
sequential scan (really slow) on the 7.2.1 box.
It's pos
