[PERFORM] is it possible to get the optimizer to use indexes with a like clause

It appears that the optimizer only uses indexes for = clause? Dave ---(end of broadcast)--- TIP 2: you can get off all lists at once with the unregister command (send unregister YourEmailAddressHere to [EMAIL PROTECTED])

Re: [PERFORM] is it possible to get the optimizer to use indexes with a like clause

[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