[EMAIL PROTECTED] (Dave Cramer) wrote:
> It appears that the optimizer only uses indexes for = clause?
It can use indices only if there is a given prefix.
Thus:
where text_field like 'A%'
can use the index, essentially transforming this into the clauses
where text_field >= 'A' and
text_field < 'B'.
You can't get much out of an index for
where text_field like '%SOMETHING'
--
(reverse (concatenate 'string "moc.enworbbc" "@" "enworbbc"))
http://www3.sympatico.ca/cbbrowne/wp.html
"When the grammar checker identifies an error, it suggests a
correction and can even makes some changes for you."
-- Microsoft Word for Windows 2.0 User's Guide, p.35:
---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?
http://archives.postgresql.org
