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, charles_shaf...@ntn-bower.com 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@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users
_______________________________________________
U2-Users mailing list
U2-Users@listserver.u2ug.org
http://listserver.u2ug.org/mailman/listinfo/u2-users