Re: Execution plan changed after upgrade from 7.3.9 to 8.2.3

I have attached the requested information.

You will see that the query is quite messy and could be easily improved.
Unfortunately, it came from a third party application and we do not have
access to the source code.

Thanks for your help,

Best Regards,
Vincent

Michael Fuhr wrote:
> On Tue, Mar 13, 2007 at 09:19:47AM +0100, vincent(dot)moreau(at)leroymerlin(dot)fr wrote:
>
>> Is there an option in the 8.2.3 to change in order to have the same
>> execution plan than before ?
>>
>
> Let's see if we can figure out why 8.2.3 is choosing a bad plan.
> Have you run ANALYZE on the tables in 8.2.3? Could you post the
> query and the complete output of EXPLAIN ANALYZE (preferably without
> wrapping) for both versions?
>
>

Ce message et toutes les pièces jointes sont établis à l'attention exclusive de leurs destinataires et sont confidentiels. Si vous recevez ce message par erreur, merci de le détruire et d'en avertir immédiatement l'expéditeur. L'internet ne permettant pas d'assurer l'intégrité de ce message, le contenu de ce message ne représente en aucun cas un engagement de la part de Leroy Merlin.