MySQL Forums
Forum List  »  NDB clusters

Secondary indexes and stats [NDB-7.4]
Posted by: julien bigeon
Date: January 16, 2019 11:02AM


Using MySQL "5.6.37-ndb-7.4.16-cluster-gpl-log" version, it appears that query execution plan is not using secondary indexes.

I can see that for all the secondary indexes created, cardinality is null (unlike innodb where i can see cardinality calculated just after index creation).

Is there an option to update stats automatically ?

Is there a restriction on secondary indexes with this NDB version ?

Thanks for your help.

Options: ReplyQuote

Written By
Secondary indexes and stats [NDB-7.4]
January 16, 2019 11:02AM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.