Re: [Gusdev-gusdev] Re: LoadTaxon.pm

[Jonathan C. <cra...@pc...>]

Deborah F. Pinney wrote:
> Several of the attributes in taxon (ncbi_tax_id, parent_id and taxon_id)
> should be indexed or they will cause the plugin to run very slowly at
> several points. That was the reason for the line:  $dbh->do("analyze table
> sres.Taxon compute statistics"); However, I suspect the line is not

Doing an analyze table won't help you if it's not properly indexed in the
first place.  All it will do is provide the optimizer with up-to-date
statistics that might help it make a better decision about index usage.
Also, if the tables that you're querying from haven't been analyzed at all
then Oracle 8i/9i will revert to using the rule-based optimizer.  Anyway,
this is typically something that's handled by the DBA, so removing it from
the plugin sounds like the best idea.

Jonathan