INDEX build failed with errors: Generating INDEX-6 - please wait..pkg_info: not found pkg_info: not found Done. make_index: p5-Math-RPN-1.09: no entry for /nonexistentlocal/lib/perl5/site_perl/5.10.1/ExtUtils/MakeMaker.pm::/local0/portmgr/tindex/ports/devel/p5-ExtUtils-MakeMaker make_index: p5-Math-RPN-1.09: no entry for /nonexistentlocal/lib/perl5/site_perl/5.10.1/ExtUtils/MakeMaker.pm::/lo
How many records are you talking about? If it's less than ten thousand, it probably doesn't matter. You could get out a stopwatch and test which works faster. Then there's always Showplan which will tell you what index, if any, that is being used by a query. http://articles.techrepublic.com.com/5100-10878_11-5064388.html -- Jerry Whittle, Microsoft Access MVP Light. Strong. Cheap
On Jan 28, 8:59 am, "Peter H. Coffin" <hell...@ninehells.com> wrote: On Thu, 28 Jan 2010 02:09:11 -0800 (PST), Jason Carlton wrote: On Jan 28, 2:00 am, "Erick T. Barkhuis" <erick.use-...@ardane.c.o.m> wrote: Jason Carlton: I have 2 different scripts that query the same table. One script queries based on 3 columns, and the other queries based on 13 columns
************************************************************** JobCircle.com is the largest regional job board in the Mid-Atlantic region, with tens of thousands of job offerings in PA, NJ, DE, MD, NY, and Washington D.C. To learn more, visit http://www.jobcircle.com?source=ng ************************************************************** Job Title: Research IT - Point and Index Production
************************************************************** JobCircle.com is the largest regional job board in the Mid-Atlantic region, with tens of thousands of job offerings in PA, NJ, DE, MD, NY, and Washington D.C. To learn more, visit http://www.jobcircle.com?source=ng ************************************************************** Job Title: Research IT - Point and Index Production