Add a second selection criteria and the benefit of the index is washed out.
-----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of Charles Stevenson Sent: Tuesday, October 25, 2011 2:39 PM To: U2 Users List Subject: Re: [U2] UniBasic Question 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 _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users