At 15:40 31/01/2008 -0800, James Dennett wrote:
> WHERE col LIKE '123%' or WHERE substr(col,1, 3) = '123'
The optimizer has a decent chance of using an index for LIKE '123%' but
I'd be surprised (and impressed) if it looks inside function calls suchas
substr for opportunities to use indexes.
Thanks guys. I'll remember to index the column, for higher performance.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
