[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.

   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"))
"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?


Reply via email to