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
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
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'