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' ")?
2) If I have an index built with Empties=NO and then query with that indexed field ="", how does it handle the query? Does it not use the index at all?
TIA, Jeff -- Jeffrey Butera, PhD Associate Director for Application and Web Services Information Technology Hampshire College 413-559-5556 _______________________________________________ U2-Users mailing list [email protected] http://listserver.u2ug.org/mailman/listinfo/u2-users
