On Mon, 6 Jun 2005 20:58:28 -0400 (EDT), you wrote: >I've got a naive Unidata question, but figured I'd throw it out there >anyway. In short, does indexing a field in a given file help performance >when querying for an empty string? ie: > >SELECT MY_TABLE WITH MY_FIELD='' > >I've always assumed yes but would like to hear other's thoughts.
Not answering your question directly, but I'd like to mention that I tend to CREATE.INDEX FILENAME FIELDNAME NO.NULLS because that way the index is much smaller, and consequently much speedier to use... In which case, the index won't be any help at all when selecting with FIELDNAME EQ "" -- Allen Egerton [EMAIL PROTECTED] ------- u2-users mailing list [email protected] To unsubscribe please visit http://listserver.u2ug.org/
