> In the first and last case the like is anchored at the beginning so it
> uses the name index. The middle case can't use that index, and how
> well distributed are the values of void (is it a boolean?)?
Ahh... I thought that the middle case could use an index, I guess that's why
I was confused..
>It's likely
> that the index isn't very selective, if most of the rows are void='f'
> then that index is probably more expensive to scan than the sequence scan
> would be.
Yep, most of the rows are void='f'..
Thanks!!
-Mitch