Frank Millman wrote: > 1. Will SELECT WHERE LOWER(colname) = 'a001' use the index, or must I create a separate index on LOWER(colname)? Sorry. RTFM. The docs clearly state that this is necessary. Frank ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend
