Hi, A question regarding https://issues.apache.org/jira/browse/IGNITE-8386?focusedCommentId=16511394&page=com.atlassian.jira.plugin.system.issuetabpanels%3Acomment-tabpanel#comment-16511394
It states that a pkey index with a compoise pKey is "effectively useless". Could you please explain why is that? We have a pKey that we are using as an index. Also, on our pKey is (customer_id, date) and affinity column is customer_id. I have noticed that most queries use AFFINITY_KEY index. Looking at the source code, AFFINITY_KEY index should not even be created since the first field of the pKey is the affinity key. Any idea what may be happening? Cheers, Eugene
