[U2] Unidata Index question

I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a query with "like" such as "FOO LIKE 'ABC...' " does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: "FOO EQ 'ABC'

Re: [U2] Unidata Index question

Hi Jeff, 1) If I have an index built for a given field FOO, and perform a query with "like" such as "FOO LIKE 'ABC...' " does it benefit from the index? Or is it only queries with equality conditions that benefit from the index (eg: "FOO EQ 'ABC' ")? An index can be used for a LIKE comparison

Re: [U2] Unidata Index question

stserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Jeffrey Butera Sent: Thursday, May 23, 2013 6:50 AM To: U2 Users List Subject: [U2] Unidata Index question I have two question about how indicies affect queries: 1) If I have an index built for a given field FOO, and perform a q