It appears I was mistaken about persistent stats, confusing them with engine
independent table stats (thought they were the same thing), which are
persistent as well. So, my settings which were intended to do something else,
caused this issue.
Am I to understand correctly, that EITS are *never*
Yep, I noticed that as well, wondering if maybe persistent (engine independent)
stats has something to do with this. Mine are set to preferably. For this
table, Product_Inventory_Summed, there are 15,841,316 rows, a few more than the
1. There are no persistent stats for this table. With preferre
Hello,
On Thu, Apr 06, 2017 at 01:51:09PM -0500, Sales wrote:
> We are noticing many dependent subqueries not working as well as they did on
> Mariadb 5.5, we’re having to add a force index.
>
> Relatively simple example:
>
> explain update Product_Master pm set Total_Inventory = (select
> sum
3 matches
Mail list logo
