On Thu, 28 Dec 2000 09:06:17 +1100, Brock Henry wrote: >I have a database, with 50,000 or so records (not sure, don't know command >to check) and created an index on it "create index borrower_num on bhist >borrnum" select count(*) from table_name; [snip] >So it seems that the perl program isn't using the index. >Anyone got any ideas? Seems odd, if the query is the same, the method used to extract should be the same. Try the "EXPLAIN" statement in a perl script, it will tell you how the data is being extracted Regards -- SLUG - Sydney Linux User Group Mailing List - http://slug.org.au/ More Info: http://slug.org.au/lists/listinfo/slug
