True on UV, too.
Compare output of these using EXPLAIN keyword:
LIST FILE WITH indexed_field = "soemthing"  EXPLAIN
LIST FILE WITH indexed_field = "soemthing"  EXPLAIN  NO.INDEX

Or forget EXPLAIN, but do it with a large file and notice the speed differnce.

On 10/25/2011 4:29 PM, wrote:
I don't know if I agree that SELECT is faster.  If you are using
indexed fields, SELECT is definitely not the good choice.
Are you saying that when there is an index, the system does not need to
read the record at all?  It just gets the SELECT list from the index?  Is
this only true in Unidata?

Charles Shaffer
Senior Analyst
NTN-Bower Corporation
U2-Users mailing list

U2-Users mailing list

Reply via email to