Re: generic plan generate poor performance

Hi čt 29. 2. 2024 v 15:28 odesílatel James Pang napsal: > Hi, >we create statistics (dependencies,distinct) on (cccid,sssid); with > real bind variables , it make good plan of Hash join , but when it try to > generic plan, it automatically convert to Nestloop and then very poor sql >

generic plan generate poor performance

Hi, we create statistics (dependencies,distinct) on (cccid,sssid); with real bind variables , it make good plan of Hash join , but when it try to generic plan, it automatically convert to Nestloop and then very poor sql performance. why generic plan change to to a poor plan "nestloop" ? how