Project:
| View Revisions: Issue #45055 | [ Back to Issue ] | ||
| Summary | 0045055: Incremental refresh of ProductCharacteristic cannot use index on updated | ||
| Revision | 2020-09-16 10:43 by rafaroda | ||
| Steps To Reproduce | To reproduce this just do an incremental refresh, and check the explain plan that results when executing the productcharechteristics query Query: select productcha0_.M_Product_Ch_Value_ID as col_0_0_, product3_.M_Product_ID as col_1_0_, characteri1_.M_Characteristic_ID as col_2_0_, characteri1_.Name as col_3_0_, characteri1_.Isactive as col_4_0_, characteri1_.EM_Obpos_Filteronwebpos as col_5_0_, characteri2_.M_Ch_Value_ID as col_6_0_ from M_Product_Ch_Value productcha0_ inner join M_Characteristic characteri1_ on productcha0_.M_Characteristic_ID=characteri1_.M_Characteristic_ID inner join M_Ch_Value characteri2_ on productcha0_.M_Ch_Value_ID=characteri2_.M_Ch_Value_ID inner join M_Product product3_ on productcha0_.M_Product_ID=product3_.M_Product_ID inner join OBRETCO_Prol_Product obretcopro4_ on product3_.M_Product_ID=obretcopro4_.M_Product_ID inner join M_ProductPrice pricingpro5_ on product3_.M_Product_ID=pricingpro5_.M_Product_ID where (productcha0_.AD_Client_ID in ($16 , $17)) and (characteri1_.M_Characteristic_ID in ($1 , $2 , $3 , $4 , $5)) and $18=$19 and $20=$21 and (productcha0_.AD_Org_ID in ($6 , $7 , $8 , $9 , $10)) and obretcopro4_.Obretco_Productlist_ID=$11 and pricingpro5_.M_PriceList_Version_ID=$12 and (obretcopro4_.Updated>$13 or product3_.Updated>$14) and $22=$23 order by productcha0_.M_Product_Ch_Value_ID limit $15 |
||
| Revision | 2020-09-15 14:56 by rafaroda | ||
| Steps To Reproduce | To reproduce this just do an incremental refresh, and check the explain plan that results when executing the productcharechteristics query Query: select productcha0_.M_Product_Ch_Value_ID as col_0_0, product3_.M_Product_ID as col_1_0, characteri1_.M_Characteristic_ID as col_2_0, characteri1_.Name as col_3_0, characteri1_.Isactive as col_4_0, characteri1_.EM_Obpos_Filteronwebpos as col_5_0, characteri2_.M_Ch_Value_ID as col_6_0 from M_Product_Ch_Value productcha0 inner join M_Characteristic characteri1 on productcha0_.M_Characteristic_ID=characteri1_.M_Characteristic_ID inner join M_Ch_Value characteri2 on productcha0_.M_Ch_Value_ID=characteri2_.M_Ch_Value_ID inner join M_Product product3 on productcha0_.M_Product_ID=product3_.M_Product_ID inner join OBRETCO_Prol_Product obretcopro4 on product3_.M_Product_ID=obretcopro4_.M_Product_ID inner join M_ProductPrice pricingpro5_ on product3_.M_Product_ID=pricingpro5_.M_Product_ID where (productcha0_.AD_Client_ID in ($15 , $16)) and (characteri1_.M_Characteristic_ID in ($1 , $2 , $3 , $4 , $5)) and $17=$18 and $19=$20 and (productcha0_.AD_Org_ID in ($6 , $7 , $8 , $9 , $10)) and obretcopro4_.Obretco_Productlist_ID=$11 and pricingpro5_.M_PriceList_Version_ID=$12 and obretcopro4_.Isactive=$21 and pricingpro5_.IsActive=$22 and productcha0_.Isactive=$23 and characteri1_.Isactive=$24 and characteri2_.Isactive=$25 and productcha0_.M_Product_Ch_Value_ID>$13 order by productcha0_.M_Product_Ch_Value_ID limit $14 |
||
| Copyright © 2000 - 2009 MantisBT Group |
 |