> From: [EMAIL PROTECTED] 
> [mailto:[EMAIL PROTECTED] On Behalf Of 
> [EMAIL PROTECTED]
> Subject: Re: [PERFORM] Execution plan changed after upgrade 
> from 7.3.9 to 8.2.3
> 
> The following did not change anything in the execution plan
> 
> ALTER TABLE lm05_t_tarif_panneau ALTER COLUMN lrg_min SET 
> STATISTICS 1000
> ALTER TABLE lm05_t_tarif_panneau ALTER COLUMN lrg_max SET 
> STATISTICS 1000
> ANALYZE lm05_t_tarif_panneau
> 
> I was able to improve response time by creating indexes, but I would 
> like to avoid changing the database structure because it is not 
> maintained by ourseleves, but by the  third party vendor.


I would actually try increasing the statistics on table
lm05_t_couleur_panneau columns ht_min, ht_max, cod_aspect, and
cod_gamme_panneau.  Because I think the planner is thrown off because the
sequential scan on lm05_t_couleur_panneau returns 280 rows when it expects
1.  Maybe to start you could just SET default_statistics_target=1000,
analyze everything, and see if that makes any difference.

Dave


---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Reply via email to